Re: [PERFORM] Wildly inaccurate query plan

2010-05-29 Thread Kevin Grittner
Thom Brown wrote: > It's a shame I can't optimise it though as the real case that runs > is with a limit of 4000 which takes a long time to complete. Perhaps you should post the real case. -Kevin -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes

Re: [PERFORM] Strange workaround for slow query

2010-05-29 Thread Sander Verhagen
Tom Lane wrote on 10-03-2010 23:37:20: > Tom Lane > 10-03-2010 23:37 > > Right now, nodeNestloop is not really aware of whether the inner scan > depends on any parameters from the outer scan, so it's a bit hard to > determine whether the join can be abandoned. However, I have 9.1 > plans to ch