Re: document the need to analyze partitioned tables - Mailing list pgsql-hackers

From Daniel Gustafsson
Subject Re: document the need to analyze partitioned tables
Date
Msg-id B2EEBF19-3FA8-4617-8AD9-BFBDC7025AD0@yesql.se
Whole thread Raw
In response to Re: document the need to analyze partitioned tables  (David Rowley <dgrowleyml@gmail.com>)
List 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 by date:

Previous
From: "Finnerty, Jim"
Date:
Subject: Re: POC, WIP: OR-clause support for indexes
Next
From: "Finnerty, Jim"
Date:
Subject: Re: Partial aggregates pushdown