Re: Strange workaround for slow query

Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote on 10-03-2010 23:37:20:

> Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
> 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 change that --- I'd like to get rid of the current
> pass-the-outer-tuple-to-ReScan hack entirely, in favor of having
> nodeNestloop explicitly set PARAM_EXEC parameters for the inner scan.
> Once that's in, it would be pretty easy to apply this optimization.

I've made it my personal standard to sit mailing list discussions out to
the end, report back on results, etc. This one has been sitting in my Inbox
for a couple of months now, waiting for me to respond. But the truth is:
you're going way over my head. And that is fine, you seem to know of the
inner workings of PostgreSQL, and I'll be waiting for future versions that
may well solve my problem -- or not, it being a great product either way.
Keep up the good work, Sander.