Re: Paged Query - Mailing list pgsql-performance

From Віталій Тимчишин
Subject Re: Paged Query
Date
Msg-id CABWW-d1KRtPWnDOh8M0vYrcHbfJ+vCnkM9UBgOoMAgGSXZH6wQ@mail.gmail.com
Whole thread Raw
In response to Re: Paged Query  (Misa Simic <misa.simic@gmail.com>)
List pgsql-performance


Понеділок, 9 липня 2012 р. користувач Misa Simic <misa.simic@gmail.com> написав:
>
>
> 2012/7/9 Gregg Jaskiewicz <gryzman@gmail.com>
>>
>> Use cursors.
>> By far the most flexible. offset/limit have their down sides.
>
>
> Well, I am not aware what down sides there are in LIMIT OFFSET what does not exist in any other solutions for paged queries...

where key > last-previous-key order by key

--
Best regards,
 Vitalii Tymchyshyn

pgsql-performance by date:

Previous
From: Yan Chunlu
Date:
Subject: Re: how could select id=xx so slow?
Next
From: Віталій Тимчишин
Date:
Subject: Re: Paged Query