Re: Autovacuum on partitioned table

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Autovacuum on partitioned table
Дата
Msg-id 20200318014910.GA19400@alvherre.pgsql
обсуждение исходный текст
Ответ на Re: Autovacuum on partitioned table  (yuzuko <yuzukohosoya@gmail.com>)
Ответы Re: Autovacuum on partitioned table  (yuzuko <yuzukohosoya@gmail.com>)
Список pgsql-hackers
On 2020-Mar-18, yuzuko wrote:

> > I think if we analyze partition tree in order from leaf partitions
> > to root table, this problem can be fixed.
> > What do you think about it?
> 
> Attach the new patch fixes the above problem.

Thanks for the new version.

I'm confused about some error messages in the regression test when a
column is mentioned twice, that changed from mentioning the table named
in the vacuum command, to mentioning the first partition.  Is that
because you changed an lappend() to lcons()?  I think you do this so
that the counters accumulate for the topmost parent that will be
processed at the end.  I'm not sure I like that too much ... I think
that needs more thought.

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



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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: WIP: WAL prefetch (another approach)
Следующее
От: David Rowley
Дата:
Сообщение: Re: [PATCH] Erase the distinctClause if the result is unique by definition