Postgres Pro
Downloads
Home   >   mailing lists

Re: Poor OFFSET performance in PostgreSQL 9.1.6 - Mailing list pgsql-performance

From Greg Spiegelberg
Subject Re: Poor OFFSET performance in PostgreSQL 9.1.6
Date
Msg-id CAEtnbpVKxxJ7TUF9mG_Mn1F2PxmrRbWe_mkpaqzPZpqpfhNLOQ@mail.gmail.com
Whole thread Raw
In response to Poor OFFSET performance in PostgreSQL 9.1.6  (<fburgess@radiantblue.com>)
List pgsql-performance
Tree view
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, <fburgess@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


pgsql-performance by date:

Previous
From:
Date:
Subject: Poor OFFSET performance in PostgreSQL 9.1.6
Next
From:
Date:
Subject: Re: Poor OFFSET performance in PostgreSQL 9.1.6