Table parameters - autovacuum Yes/No

From: <endre_pekarik(at)yahoo(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Table parameters - autovacuum Yes/No
Date: 2022-08-02 16:25:36
Message-ID: 09af01d8a68c$803cf360$80b6da20$@yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-admin by date

  From Date Subject
Next Message David Steele 2022-08-02 18:16:31 Re: WAL restore/recovery fills pg_wal volume
Previous Message endre_pekarik 2022-08-02 15:50:34 RE: Partitioned table with fillfactor