Re: autovacuum on system catalog
| От | Guillaume Lelarge |
|---|---|
| Тема | Re: autovacuum on system catalog |
| Дата | |
| Msg-id | CAECtzeXaW-TLUpoUi0So3HzSxjChkqsJoNg-7u=MeivHnbzycA@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: autovacuum on system catalog (Artem Tomyuk <admin@leboutique.com>) |
| Список | pgsql-admin |
2018-04-03 14:23 GMT+02:00 Artem Tomyuk <admin@leboutique.com>:
I'am, trying to set it as built in postgres user.... Maybe there is no such feature to set autovac settings on system catalogs?
You cannot alter a system catalog. "Changing any part of a system catalog table is not permitted." (https://www.postgresql.org/docs/10/static/sql-altertable.html)
2018-04-03 15:21 GMT+03:00 Ron <ronljohnsonjr@gmail.com>:I think you can only do that as superuser.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
--
Angular momentum makes the world go 'round.
--
Guillaume.
В списке pgsql-admin по дате отправления: