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
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