autovacuum on system catalog

From: Artem Tomyuk <admin(at)leboutique(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: autovacuum on system catalog
Date: 2018-04-03 12:16:34
Message-ID: CANYYVqLZKPi8F9jVSJ8akyo3Efvm_2Ta8=zC7MWUzURyhrr8Xg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ron 2018-04-03 12:21:05 Re: autovacuum on system catalog
Previous Message Artem Tomyuk 2018-04-03 08:51:07 Re: avtovacuum queue