pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed

Table parameters - autovacuum Yes/No
2+ messages / 1 participants
[nested] [flat]

* Table parameters - autovacuum Yes/No
@ 2022-08-02 16:25  endre_pekarik@yahoo.com
  0 siblings, 0 replies; 2+ messages in thread

From: endre_pekarik@yahoo.com @ 2022-08-02 16:25 UTC (permalink / raw)
  To: 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 



 

 

Attachments:

image001.png (image/png, 110.1K) download
  view image

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Table parameters - autovacuum Yes/No
@ 2022-08-04 12:35  endre_pekarik@yahoo.com
  0 siblings, 0 replies; 2+ messages in thread

From: endre_pekarik@yahoo.com @ 2022-08-04 12:35 UTC (permalink / raw)
  To: 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 



 

 

Attachments:

image001.png (image/png, 110.1K) download
  view image

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2022-08-04 12:35 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2022-08-02 16:25 Table parameters - autovacuum Yes/No endre_pekarik@yahoo.com
2022-08-04 12:35 Table parameters - autovacuum Yes/No endre_pekarik@yahoo.com

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