Skip site navigation (1) Skip section navigation (2)

Re: Slow query when using ORDER BY *and* LIMIT

From: davidsarmstrong <dsatemp-1(at)yahoo(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Slow query when using ORDER BY *and* LIMIT
Date: 2011-10-13 19:34:09
Message-ID: (view raw or whole thread)
Lists: pgsql-performance
I'm running into the same problem. I removed the limit and it was fine. I
guess I could have removed the order by as well but it doesn't help if you
really need both.

Have you found any more information on this?


Dave (Armstrong)

View this message in context:
Sent from the PostgreSQL - performance mailing list archive at

In response to


pgsql-performance by date

Next:From: Tom LaneDate: 2011-10-14 04:25:53
Subject: Re: Rapidly finding maximal rows
Previous:From: Vishnu S.Date: 2011-10-13 12:52:32
Subject: Tablespace files deleted automatically.

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group