Table parameters - autovacuum Yes/No - Mailing list pgsql-admin

From
Subject Table parameters - autovacuum Yes/No
Date
Msg-id 09af01d8a68c$803cf360$80b6da20$@yahoo.com
Whole thread Raw
List pgsql-admin

Hello,

 

When I turn on AutoVacuum on a partitioned table via ALTER TABLE, (on the individual leaf partitions), where can I see it in the GUI PGadmin 4? If I look at the properties of the table, I see no Autovacuum

 

ALTER TABLE partition1 SET (autovacuum_vacuum_scale_factor = 0.0);

ALTER TABLE partition1 SET (autovacuum_vacuum_threshold = 100000);

ALTER TABLE partition2 SET (autovacuum_vacuum_scale_factor = 0.0);

ALTER TABLE partition2 SET (autovacuum_vacuum_threshold = 100000);

ALTER TABLE   partition1 SET (autovacuum_enabled = true);

ALTER TABLE   partition2 SET (autovacuum_enabled = true);

 

 

Table parameter after the ALTER statements

 

 

Attachment

pgsql-admin by date:

Previous
From:
Date:
Subject: RE: Partitioned table with fillfactor
Next
From: David Steele
Date:
Subject: Re: WAL restore/recovery fills pg_wal volume