Postgres Pro
Downloads
Home   >   mailing lists

autovacuum on system catalog - Mailing list pgsql-admin

From Artem Tomyuk
Subject autovacuum on system catalog
Date
Msg-id CANYYVqLZKPi8F9jVSJ8akyo3Efvm_2Ta8=zC7MWUzURyhrr8Xg@mail.gmail.com
Whole thread Raw
Responses Re: autovacuum on system catalog  (Ron <ronljohnsonjr@gmail.com>)
List pgsql-admin
Tree view
Hi.

Why its not possible to set autovacuum settings on pg_attribute?

alter table pg_attribute set (autovacuum_vacuum_scale_factor = 0.0);
alter table pg_attribute set (autovacuum_vacuum_threshold = 500);

ERROR:  permission denied: "pg_attribute" is a system catalog
********** Ошибка **********

ERROR: permission denied: "pg_attribute" is a system catalog
SQL-состояние: 42501

pgsql-admin by date:

Previous
From: Artem Tomyuk
Date:
Subject: Re: avtovacuum queue
Next
From: Ron
Date:
Subject: Re: autovacuum on system catalog