Dave, Since I control the application that was performing the query and I've separated my data into daily partitioned tables (which enforced my order by clause on a macro-level), I took Stephen's advice and implemented the nested loop over each daily table from within the application versus having Postgres figure it out for me. Sorry I don't have a better answer for you.
Mike On Thu, Oct 13, 2011 at 3:34 PM, davidsarmstrong <dsatem...@yahoo.com>wrote: > 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 >
