Re: what does "initplan" operation in explain output mean?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: what does "initplan" operation in explain output mean?
Дата
Msg-id 20342.1280770187@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: what does "initplan" operation in explain output mean?  (Mark Rostron <mrostron@ql2.com>)
Список pgsql-performance
Дерево обсуждения 
Mark Rostron <mrostron@ql2.com> writes:
> So am I right in assuming that the aggregate sub-query ( against work_active ) results will not assist with
constraintexclusion in the sub-query against work_unit (if we introduce range partitions on this table)? 

Dunno.  You didn't actually show what you were hoping would work, or
work differently as the case may be.

            regards, tom lane

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

Предыдущее
От: Mark Rostron
Дата:
Сообщение: Re: what does "initplan" operation in explain output mean?
Следующее
От: Maciek Sakrejda
Дата:
Сообщение: Optimizing NOT IN plans / verify rewrite