Re: Strange workaround for slow query

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Tom Lane <tgl@xxxxxxxxxxxxx> wrote on 10-03-2010 23:37:20:

> Tom Lane <tgl@xxxxxxxxxxxxx>

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


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux