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.