Re: Can this query go faster???

From: Tino Wildenhain <tino(at)wildenhain(dot)de>
To: Joost Kraaijeveld <J(dot)Kraaijeveld(at)Askesis(dot)nl>
Cc: Csaba Nagy <nagy(at)ecircle-ag(dot)com>, Pgsql-Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Can this query go faster???
Date: 2005-12-06 11:36:50
Message-ID: 439577D2.9090208@wildenhain.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message David Lang 2005-12-06 11:39:41 Re: BLCKSZ
Previous Message Joost Kraaijeveld 2005-12-06 11:21:24 Re: Can this query go faster???