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: 1318534448999-4900348.post@n5.nabble.com (view raw or flat)
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?

Thanks!

Dave (Armstrong)

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Slow-query-when-using-ORDER-BY-and-LIMIT-tp4555260p4900348.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.

In response to

Responses

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-2014 The PostgreSQL Global Development Group