On Wed, Aug 28, 2013 at 01:39:46PM -0700, fburgess@xxxxxxxxxxxxxxx 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
