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

From
Subject Poor OFFSET performance in PostgreSQL 9.1.6
Date
Msg-id 20130828133946.5a830134ae84016b0174832fdc1a3173.53df957760.wbe@email11.secureserver.net
Whole thread Raw
Responses Re: Poor OFFSET performance in PostgreSQL 9.1.6  (Greg Spiegelberg <gspiegelberg@gmail.com>)
Re: Poor OFFSET performance in PostgreSQL 9.1.6  (Merlin Moncure <mmoncure@gmail.com>)
Re: Poor OFFSET performance in PostgreSQL 9.1.6  (David Rowley <dgrowleyml@gmail.com>)
Re: Poor OFFSET performance in PostgreSQL 9.1.6  (hubert depesz lubaczewski <depesz@depesz.com>)
List pgsql-performance
<span style="font-family:Verdana; color:#000000; font-size:10pt;"><div>Can anyone offer suggestions on how I can
optimizea query that contains the LIMIT OFFSET clause?</div><div><br /></div><div>The explain plan of the query is
includedin the notepad attachment.</div><div><br /></div><div>thanks</div><div><br /></div><div><br /></div></span> 

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: SQL statement over 500% slower with 9.2 compared with 9.1
Next
From: Greg Spiegelberg
Date:
Subject: Re: Poor OFFSET performance in PostgreSQL 9.1.6