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-04 12:35:53
Message-ID: 011601d8a7fe$bd99ba90$38cd2fb0$@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. Is there a way
within GUI PGAdmin 4 to see that the table has Autovacuum turned on?

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 endre_pekarik 2022-08-04 12:39:51 Slow Scripts - Create Script
Previous Message Bo Victor Thomsen 2022-08-04 07:27:33 Re: doubts