Re: Enabling autovacuum per table

On Mon, 15 Oct 2018 at 2:58 pm, Arthur Zakirov

<a.zakirov@postgrespro.ru> wrote:

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