Re: autovacuum on system catalog - Mailing list pgsql-admin

On 04/03/2018 07:16 AM, Artem Tomyuk wrote:

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

I think you can only do that as superuser.

--
Angular momentum makes the world go 'round.