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. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
