Re: [SQL] OFFSET impact on Performance???
От | Andrei Bintintan |
---|---|
Тема | Re: [SQL] OFFSET impact on Performance??? |
Дата | |
Msg-id | 020d01c4fef6$595bb9d0$0b00a8c0@forge обсуждение исходный текст |
Ответ на | OFFSET impact on Performance??? ("Andrei Bintintan" <klodoma@ar-sd.net>) |
Ответы |
Re: [SQL] OFFSET impact on Performance???
Re: [SQL] OFFSET impact on Performance??? |
Список | pgsql-performance |
> If you're using this to provide "pages" of results, could you use a > cursor? What do you mean by that? Cursor? Yes I'm using this to provide "pages", but If I jump to the last pages it goes very slow. Andy. ----- Original Message ----- From: "Richard Huxton" <dev@archonet.com> To: "Andrei Bintintan" <klodoma@ar-sd.net> Cc: <pgsql-sql@postgresql.org>; <pgsql-performance@postgresql.org> Sent: Thursday, January 20, 2005 2:10 PM Subject: Re: [SQL] OFFSET impact on Performance??? > Andrei Bintintan wrote: >> Hi to all, >> >> I have the following 2 examples. Now, regarding on the offset if it >> is small(10) or big(>50000) what is the impact on the performance of >> the query?? I noticed that if I return more data's(columns) or if I >> make more joins then the query runs even slower if the OFFSET is >> bigger. How can I somehow improve the performance on this? > > There's really only one way to do an offset of 1000 and that's to fetch > 1000 rows and then some and discard the first 1000. > > If you're using this to provide "pages" of results, could you use a > cursor? > > -- > Richard Huxton > Archonet Ltd >
В списке pgsql-performance по дате отправления: