Re: document the need to analyze partitioned tables

From: Daniel Gustafsson <daniel(at)yesql(dot)se>
To: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
Cc: David Rowley <dgrowleyml(at)gmail(dot)com>, Bruce Momjian <bruce(at)momjian(dot)us>, Justin Pryzby <pryzby(at)telsasoft(dot)com>, Nathan Bossart <nathandbossart(at)gmail(dot)com>, Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, Álvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, yuzuko <yuzukohosoya(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: document the need to analyze partitioned tables
Date: 2023-08-01 20:24:54
Message-ID: B2EEBF19-3FA8-4617-8AD9-BFBDC7025AD0@yesql.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> On 13 Jul 2023, at 00:21, David Rowley <dgrowleyml(at)gmail(dot)com> wrote:
>
> On Wed, 25 Jan 2023 at 21:43, David Rowley <dgrowleyml(at)gmail(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Finnerty, Jim 2023-08-01 20:25:55 Re: Partial aggregates pushdown
Previous Message Finnerty, Jim 2023-08-01 20:11:07 Re: POC, WIP: OR-clause support for indexes