Re: autovacuum on system catalog

I'am, trying to set it as built in postgres user.... Maybe there is no such
feature to set autovac settings on system catalogs?

2018-04-03 15:21 GMT+03:00 Ron <ronljohnsonjr(at)gmail(dot)com>:

> 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.
>
>