Re: Enabling autovacuum per table

Поиск
Список
Период
Сортировка
От Arthur Zakirov
Тема Re: Enabling autovacuum per table
Дата
Msg-id 078d5504-ac33-ea9a-5ff5-85adfadbb1bc@postgrespro.ru
обсуждение исходный текст
Ответ на Enabling autovacuum per table  (Rijo Roy <rjo_roy@yahoo.com>)
Ответы Re: Enabling autovacuum per table
Список pgsql-general
On 10/15/18 11:01 AM, Rijo Roy wrote:
> Hello Experts,
> 
> Is there any possibility for autovacuum to work on a user table if we set
> Alter table sometable set (autovacuum_enabled = true) ; even if the 
> parameter autovacuum = off in Postgresql.conf
> 
> I am using Postgresql 10 on Linux 6.9.
> 
> According to me, it won't work without setting autovacuum = on except 
> for Template0 database. What is your opinion?

I think you are right, autovacuum won't vacuum and analyze a table 
without setting autovacuum = on. But PostgreSQL might want to force 
vacuum if a table is at risk of wraparound.

-- 
Arthur Zakirov
Postgres Professional: http://www.postgrespro.com
Russian Postgres Company


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

Предыдущее
От: Durgamahesh Manne
Дата:
Сообщение: Re: Regarding varchar max length in postgres
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: Regarding varchar max length in postgres