From: Justin Pryzby <pryzby@telsasoft.com>
To: Alvaro Herrera <alvherre@alvh.no-ip.org>
Cc: yuzuko <yuzukohosoya@gmail.com>
Cc: Tomas Vondra <tomas.vondra@enterprisedb.com>
Cc: David Steele <david@pgmasters.net>
Cc: Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Cc: Daniel Gustafsson <daniel@yesql.se>
Cc: Amit Langote <amitlangote09@gmail.com>
Cc: Masahiko Sawada <masahiko.sawada@2ndquadrant.com>
Cc: Laurenz Albe <laurenz.albe@cybertec.at>
Cc: pgsql-hackers@lists.postgresql.org, Greg Stark <stark@mit.edu>
Subject: Re: Autovacuum on partitioned table (autoanalyze)
Date: Thu, 8 Apr 2021 17:00:42 -0500
Message-ID: <20210408220042.GM6592@telsasoft.com> (raw)
In-Reply-To: <20210408215625.GA17048@alvherre.pgsql>
References: <20210408213051.GL6592@telsasoft.com>
<20210408215625.GA17048@alvherre.pgsql>
On Thu, Apr 08, 2021 at 05:56:25PM -0400, Alvaro Herrera wrote:
> On 2021-Apr-08, Justin Pryzby wrote:
>
> > commit 0827e8af70f4653ba17ed773f123a60eadd9f9c9
> > | This also introduces necessary reloptions support for partitioned tables
> > | (autovacuum_enabled, autovacuum_analyze_scale_factor,
> > | autovacuum_analyze_threshold). It's unclear how best to document this
> > | aspect.
> >
> > At least this part needs to be updated - see also ed62d3737.
> >
> > doc/src/sgml/ref/create_table.sgml- The storage parameters currently
> > doc/src/sgml/ref/create_table.sgml- available for tables are listed below.
> > ...
> > doc/src/sgml/ref/create_table.sgml: Specifying these parameters for partitioned tables is not supported,
> > doc/src/sgml/ref/create_table.sgml- but you may specify them for individual leaf partitions.
>
> Ah, thanks for pointing it out. How about the attached?
>
> This new bit reads weird:
>
> + Most parameters are not supported on partitioned tables, with exceptions
> + noted below; you may specify them for individual leaf partitions.
"Except where noted, these parameters are not supported on partitioned tables."
--
Justin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: pryzby@telsasoft.com, alvherre@alvh.no-ip.org, yuzukohosoya@gmail.com, tomas.vondra@enterprisedb.com, david@pgmasters.net, horikyota.ntt@gmail.com, daniel@yesql.se, amitlangote09@gmail.com, masahiko.sawada@2ndquadrant.com, laurenz.albe@cybertec.at, stark@mit.edu
Subject: Re: Autovacuum on partitioned table (autoanalyze)
In-Reply-To: <20210408220042.GM6592@telsasoft.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox