On Wed, Aug 28, 2013 at 01:39:46PM -0700, fburg...@radiantblue.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 -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
