Postgres Pro
Downloads
Home   >   mailing lists

Re: Slow query when using ORDER BY *and* LIMIT - Mailing list pgsql-performance

From davidsarmstrong
Subject Re: Slow query when using ORDER BY *and* LIMIT
Date
Msg-id 1318534448999-4900348.post@n5.nabble.com
Whole thread Raw
In response to Slow query when using ORDER BY *and* LIMIT  (Jonathan <jonathan@kc8onw.net>)
Responses Re: Slow query when using ORDER BY *and* LIMIT  (Michael Viscuso <michael.viscuso@getcarbonblack.com>)
List pgsql-performance
Tree view 
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.

pgsql-performance by date:

Previous
From: "Vishnu S."
Date:
Subject: Tablespace files deleted automatically.
Next
From: Svetlin Manavski
Date:
Subject: Join over two tables of 50K records takes 2 hours