On Wed, Aug 28, 2013 at 01:39:46PM -0700, fburgess(at)radiantblue(dot)com wrote:
> Can anyone offer suggestions on how I can optimize a query that contains the LIMIT OFFSET clause?
> The explain plan of the query is included in the notepad attachment.
> thanks
large offsets are slow, and there is no real escape from it.
You can change your paging solution, though, to something that will be
faster.
Possible solutions/optimizations:
http://www.depesz.com/2007/08/29/better-results-paging-in-postgresql-82/
or
http://www.depesz.com/2011/05/20/pagination-with-fixed-order/
Best regards,
depesz