Re: pgsql: Support partition pruning at execution time

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: pgsql: Support partition pruning at execution time
Дата
Msg-id 20180417192649.kuwcdv7btvdo2iuq@alvherre.pgsql
обсуждение исходный текст
Ответ на Re: pgsql: Support partition pruning at execution time  (David Rowley <david.rowley@2ndquadrant.com>)
Ответы Re: pgsql: Support partition pruning at execution time  (David Rowley <david.rowley@2ndquadrant.com>)
Список pgsql-committers
David Rowley wrote:

> I've made another pass over the nodeAppend.c code and I'm unable to
> see what might cause this, although I did discover a bug where
> first_partial_plan is not set taking into account that some subplans
> may have been pruned away during executor init. The only thing I think
> this would cause is for parallel workers to not properly help out with
> some partial plans if some earlier subplans were pruned. I can see no
> reason for this to have caused this particular issue since the
> first_partial_plan would be 0 with and without the attached fix.

Pushed this.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: pgsql: Update Append's idea of first_partial_plan
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: pgsql: Fix confusion on the padding of GIDs in on commit and abortreco