Re: Can this query go faster??? - Mailing list pgsql-performance

From Tino Wildenhain
Subject Re: Can this query go faster???
Date
Msg-id 439577D2.9090208@wildenhain.de
Whole thread Raw
In response to Re: Can this query go faster???  (Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>)
Responses Re: Can this query go faster???  (Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>)
List pgsql-performance
Joost Kraaijeveld schrieb:
> Hi Tino,
>
..
>
>>Cursor would work too but you would need to have a persistent connection.
>
> I just tried it: a cursor is not faster (what does not surprise me at
> all, as the amount of work looks the same to me)

Actually no, if you scroll forward, you just ask the database for the
next rows to materialize. So if you are ahead in your database and
ask for next rows, it should be faster then working w/ an offset
from start each time.



pgsql-performance by date:

Previous
From: Joost Kraaijeveld
Date:
Subject: Re: Can this query go faster???
Next
From: David Lang
Date:
Subject: Re: BLCKSZ