Horton

Re: Autovacuum on partitioned table (autoanalyze)

Justin Pryzby <pryzby@telsasoft.com>

View thread View on postgr.es
From: Justin Pryzby <pryzby@telsasoft.com>
To: Alvaro Herrera <alvherre@alvh.no-ip.org>
Cc: yuzuko <yuzukohosoya@gmail.com>, Tomas Vondra <tomas.vondra@enterprisedb.com>, David Steele <david@pgmasters.net>, Kyotaro Horiguchi <horikyota.ntt@gmail.com>, Daniel Gustafsson <daniel@yesql.se>, Amit Langote <amitlangote09@gmail.com>, Masahiko Sawada <masahiko.sawada@2ndquadrant.com>, Laurenz Albe <laurenz.albe@cybertec.at>, pgsql-hackers@lists.postgresql.org, Greg Stark <stark@mit.edu>
Date: 2021-04-08T22:00:42Z
Lists: pgsql-hackers 
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

Commits

  1. Keep stats up to date for partitioned tables

  2. Revert analyze support for partitioned tables

  3. Document ANALYZE storage parameters for partitioned tables

  4. autovacuum: handle analyze for partitioned tables