Horton

Re: autovacuum is ON in the system but commented out in postgresql.conf

Laurenz Albe <laurenz.albe@cybertec.at>

View thread View on postgr.es
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: "Subramanian,Ramachandran" <ramachandran.subramanian@alte-leipziger.de>, "pgsql-novice@lists.postgresql.org" <pgsql-novice@lists.postgresql.org>
Date: 2026-05-13T12:17:00Z
Lists: pgsql-novice 
On Wed, 2026-05-13 at 10:15 +0000, Subramanian,Ramachandran wrote:
> I see the autovacuum is on , but when I look at postgresql.conf all the
> relevant lines are commented out.  How should I understand this ?

By checking where your current setting originates:

  SELECT source, sourcefile, sourceline, pending_restart
  FROM pg_settings
  WHERE name = 'autovacuum';

Yours,
Laurenz Albe