Re: Can this query go faster???

Поиск
Список
Период
Сортировка
От Tino Wildenhain
Тема Re: Can this query go faster???
Дата
Msg-id 439577D2.9090208@wildenhain.de
обсуждение исходный текст
Ответ на Re: Can this query go faster???  (Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>)
Ответы Re: Can this query go faster???  (Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>)
Список 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 по дате отправления:

Предыдущее
От: Joost Kraaijeveld
Дата:
Сообщение: Re: Can this query go faster???
Следующее
От: David Lang
Дата:
Сообщение: Re: BLCKSZ