Poor OFFSET performance in PostgreSQL 9.1.6

From:	<fburgess(at)radiantblue(dot)com>
To:	pgsql-performance(at)postgresql(dot)org
Subject:	Poor OFFSET performance in PostgreSQL 9.1.6
Date:	2013-08-28 20:39:46
Message-ID:	20130828133946.5a830134ae84016b0174832fdc1a3173.53df957760.wbe@email11.secureserver.net
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2013-08-28 20:39:46 from <fburgess(at)radiantblue(dot)com> 📎  2013-08-28 21:26:07 from Greg Spiegelberg <gspiegelberg(at)gmail(dot)com>  2013-08-28 23:10:37 from Merlin Moncure <mmoncure(at)gmail(dot)com>  2013-08-29 04:43:50 from David Rowley <dgrowleyml(at)gmail(dot)com>  2013-08-29 11:00:22 from hubert depesz lubaczewski <depesz(at)depesz(dot)com>
Lists:	pgsql-performance

Attachment	Content-Type	Size
unknown_filename	text/html	363 bytes
tuning_SQL_with_offest.txt	text/plain	4.0 KB

Responses

• Re: Poor OFFSET performance in PostgreSQL 9.1.6 at 2013-08-28 21:26:07 from Greg Spiegelberg
• Re: Poor OFFSET performance in PostgreSQL 9.1.6 at 2013-08-28 23:10:37 from Merlin Moncure
• Re: Poor OFFSET performance in PostgreSQL 9.1.6 at 2013-08-29 04:43:50 from David Rowley
• Re: Poor OFFSET performance in PostgreSQL 9.1.6 at 2013-08-29 11:00:22 from hubert depesz lubaczewski

Browse pgsql-performance by date

	From	Date	Subject
Next Message	Greg Spiegelberg	2013-08-28 21:26:07	Re: Poor OFFSET performance in PostgreSQL 9.1.6
Previous Message	Tom Lane	2013-08-28 19:08:10	Re: SQL statement over 500% slower with 9.2 compared with 9.1