Two solutions come to mind. First possibility is table partitioning on the column you're sorting. Second, depending on your application, is to use a cursor. Cursor won't help with web applications however a stateful application could benefit.
HTH -Greg On Wed, Aug 28, 2013 at 2:39 PM, <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 > > > > > -- > Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-performance > >
