Use cursors. By far the most flexible. offset/limit have their down sides.
-- Sent via pgsql-performance mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
- [PERFORM] Paged Query Hermann Matthes
- Re: [PERFORM] Paged Query Віталій Тимчишин
- Re: [PERFORM] Paged Query Albe Laurenz
- Re: [PERFORM] Paged Query Greg Spiegelberg
- Re: [PERFORM] Paged Query Misa Simic
- Re: [PERFORM] Paged Query Gregg Jaskiewicz
- Re: [PERFORM] Paged Query Craig Ringer
- Re: [PERFORM] Paged Query Shaun Thomas
- Re: [PERFORM] Paged ... Craig James
- Re: [PERFORM] Pa... Greg Spiegelberg
- Re: [PERFORM] Paged ... Craig Ringer
- Re: [PERFORM] Paged Query Misa Simic
- Re: [PERFORM] Paged Query Andrew Dunstan
- Re: [PERFORM] Paged ... Gurjeet Singh
- Re: [PERFORM] Paged Query Віталій Тимчишин
- Re: [PERFORM] Paged Query Віталій Тимчишин
