Re: Autovacuum on partitioned table (autoanalyze)

Justin Pryzby <pryzby@telsasoft.com>

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-08T21:30:51Z
Lists: pgsql-hackers
On Thu, Apr 08, 2021 at 01:20:14AM -0400, Alvaro Herrera wrote:
> On 2021-Apr-07, Alvaro Herrera wrote:
> 
> > OK, I bit the bullet and re-did the logic in the way I had proposed
> > earlier in the thread: do the propagation on the collector's side, by
> > sending only the list of ancestors: the collector can read the tuple
> > change count by itself, to add it to each ancestor.  This seems less
> > wasteful.  Attached is v16 which does it that way and seems to work
> > nicely under my testing.
> 
> Pushed with this approach.  Thanks for persisting with this.

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.

-- 
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