Re: autovacuum doesnt run on the pg_toast_id table

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: autovacuum doesnt run on the pg_toast_id table
Дата
Msg-id 201901171909.eb4o7z7hikas@alvherre.pgsql
обсуждение исходный текст
Ответ на Re: 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 did it for the original table. But I see in the logs that the autovacuun
> on the toasted table isn't synced with the autovacuun of the original
> table. Therefore I thought that it worth to set it also for the toasted
> table. Can you explain why in the logs I see more vacuums of the original
> table then the toasted table ? Should they vacuumed together ?

No, they are processed separately, according to the formula explained in
the documentation.

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


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

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