Re: autovacuum doesnt run on the pg_toast_id table

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: autovacuum doesnt run on the pg_toast_id table
Дата
Msg-id 201901171752.2cdiwqezrwjk@alvherre.pgsql
обсуждение исходный текст
Ответ на autovacuum doesnt run on the pg_toast_id table  (Mariel Cherkassky <mariel.cherkassky@gmail.com>)
Ответы Re: autovacuum doesnt run on the pg_toast_id table  (Mariel Cherkassky <mariel.cherkassky@gmail.com>)
Список pgsql-performance
On 2019-Jan-17, Mariel Cherkassky wrote:

> I tried to set the same threshold for the toasted table but got an error
> that it is a catalog table and therefore permission is denied.
> 2019-01-17 12:04:15 EST db116109  ERROR:  permission denied:
> "pg_toast_13388392" is a system catalog
> 2019-01-17 12:04:15 EST db116109  STATEMENT:  alter table
> pg_toast.pg_toast_13388392 set (autovacuum_vacuum_scale_factor=0.05);

The right way to do this is
  alter table main_table set (toast.autovacuum_vacuum_scale_factor = 0.05);

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


В списке pgsql-performance по дате отправления:

Предыдущее
От: Justin Pryzby
Дата:
Сообщение: Re: autovacuum doesnt run on the pg_toast_id table
Следующее
От: Mariel Cherkassky
Дата:
Сообщение: Re: autovacuum doesnt run on the pg_toast_id table