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?
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
pgsql-performance by date
|Next:||From: Tom Lane||Date: 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.|