Postgres Pro
Downloads
Home   >   mailing lists

Enabling autovacuum per table - Mailing list pgsql-general

From Rijo Roy
Subject Enabling autovacuum per table
Date
Msg-id 76007915.10489869.1539590480467@mail.yahoo.com
Whole thread Raw
Responses Re: Enabling autovacuum per table  (Arthur Zakirov <a.zakirov@postgrespro.ru>)
Re: Enabling autovacuum per table  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Tree view
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? 

Thanks, 

pgsql-general by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: Is there any impact if "#wal_keep_segments = 0 " and"checkpoint_segments = 128" postgresql.conf file.
Next
From: Durgamahesh Manne
Date:
Subject: Re: Regarding varchar max length in postgres