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

From David Rowley
Subject Re: document the need to analyze partitioned tables
Date
Msg-id CAApHDvqmadnbpKVJHohL+5iM-6egqE4eo34W-B3C4D93WnbhxA@mail.gmail.com
Whole thread Raw
In response to Re: document the need to analyze partitioned tables  (David Rowley <dgrowleyml@gmail.com>)
Responses Re: document the need to analyze partitioned tables  (Daniel Gustafsson <daniel@yesql.se>)
List pgsql-hackers
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.

David



pgsql-hackers by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: CommandStatus from insert returning when using a portal.
Next
From: Michael Paquier
Date:
Subject: Re: 'ERROR: attempted to update invisible tuple' from 'ALTER INDEX ... ATTACH PARTITION' on parent index