From: PG Doc comments form <noreply@postgresql.org>
To: pgsql-docs@lists.postgresql.org
Cc: rruenroeng@gmail.com
Subject: Partitioned tables are not processed by autovacuum.
Date: Mon, 31 Oct 2022 22:32:58 +0000
Message-ID: <166725557839.630.12125626056953515266@wrigleys.postgresql.org> (raw)
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/15/runtime-config-autovacuum.html
Description:
There is a statement in the Postgres Docs: "Partitioned tables are not
processed by autovacuum."
https://www.postgresql.org/docs/15/routine-vacuuming.html
What does the above statement mean?
Does autovacuum not process both the parent and the child tables in a
partition relationship?
What is the definition of a partitioned table?
I have a table with 50+ million rows that gets data added to/wiped from it
every 90 days. We are planning to break this table into a few thousand
partitions. More partitions will likely be added in the future, but we don't
have plans to delete any of the partitions. Will we need to manually track
the statistics of these partitions and manually vacuum the tables or will
autovacuum help to manage them?
I found the above statement unclear.
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-docs@postgresql.org
Cc: noreply@postgresql.org, pgsql-docs@lists.postgresql.org, rruenroeng@gmail.com
Subject: Re: Partitioned tables are not processed by autovacuum.
In-Reply-To: <166725557839.630.12125626056953515266@wrigleys.postgresql.org>
* 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