Re: Autovacuum on Partitioned Tables

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Ryan Ruenroeng <rruenroeng(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Autovacuum on Partitioned Tables
Date: 2022-11-01 06:51:27
Message-ID: 317016f71b5cad064b1cc11150e8fdaaed2c514d.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, 2022-10-31 at 17:26 -0500, Ryan Ruenroeng wrote:
> There is a statement in the Postgres Docs: "Partitioned tables are not processed by autovacuum."
>
> What does the above statement mean?
> Does autovacuum not process both the parent and the child tables in a partition relationship? 

I agree that this is unclear and have proposed an improvement:

https://postgr.es/m/1fd81ddc7710a154834030133c6fea41e55c8efb.camel@cybertec.at

Yours,
Laurenz Albe

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ron 2022-11-01 07:54:26 Re: Autovacuum on Partitioned Tables
Previous Message Laurenz Albe 2022-11-01 06:48:52 Re: Putting the O/S user for "local" "peer" authentication in the "postgres" group vs chmod'ing the "pg*.conf" files to be readable by "all"