Re: document the need to analyze partitioned tables

Поиск
Список
Период
Сортировка
От Daniel Gustafsson
Тема Re: document the need to analyze partitioned tables
Дата
Msg-id B2EEBF19-3FA8-4617-8AD9-BFBDC7025AD0@yesql.se
обсуждение исходный текст
Ответ на Re: document the need to analyze partitioned tables  (David Rowley <dgrowleyml@gmail.com>)
Список pgsql-hackers
> On 13 Jul 2023, at 00:21, David Rowley <dgrowleyml@gmail.com> wrote:
> 
> On Wed, 25 Jan 2023 at 21:43, David Rowley <dgrowleyml@gmail.com> wrote:
>> While I agree that the majority of partitions are likely to be
>> relkind='r', which you might ordinarily consider a "normal table", you
>> just might change your mind when you try to INSERT or UPDATE records
>> that would violate the partition constraint. Some partitions might
>> also be themselves partitioned tables and others might be foreign
>> tables. That does not really matter much when it comes to what
>> autovacuum does or does not do, but I'm not really keen to imply in
>> our documents that partitions are "normal tables".
> 
> Based on the above, I'm setting this to waiting on author.

Based on the above, and that the thread has been stalled for months, I'm
marking this returned with feedback.  Please feel free to resubmit a new
version of the patch to a future CF.

--
Daniel Gustafsson




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

Предыдущее
От: "Finnerty, Jim"
Дата:
Сообщение: Re: POC, WIP: OR-clause support for indexes
Следующее
От: "Finnerty, Jim"
Дата:
Сообщение: Re: Partial aggregates pushdown