Re: autovacuum on system catalog

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.




[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux