Re: Strange workaround for slow query

Поиск
Список
Период
Сортировка
От Sander Verhagen
Тема Re: Strange workaround for slow query
Дата
Msg-id OF645E063A.0499CDD2-ONC1257732.00744183-C1257732.00749BDE@imtechrelay.nl
обсуждение исходный текст
Ответ на Re: Strange workaround for slow query  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance

Tom Lane <tgl@sss.pgh.pa.us> wrote on 10-03-2010 23:37:20:

> Tom Lane <tgl@sss.pgh.pa.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.

В списке pgsql-performance по дате отправления:

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Wildly inaccurate query plan
Следующее
От: Jesper Krogh
Дата:
Сообщение: planner costs in "warm cache" tests