Postgres auto vacuum - Disable

From: "Karthik Jagadish (kjagadis)" <kjagadis(at)cisco(dot)com>
To: "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Cc: "Chandruganth Ayyavoo Selvam (chaayyav)" <chaayyav(at)cisco(dot)com>, "Prasanna Satyanarayanan (prassaty)" <prassaty(at)cisco(dot)com>, "Jaganbabu M (jmunusam)" <jmunusam(at)cisco(dot)com>, "Joel Mariadasan (jomariad)" <jomariad(at)cisco(dot)com>
Subject: Postgres auto vacuum - Disable
Date: 2022-11-07 11:27:06
Message-ID: IA1PR11MB6170E4FD614F5E73E50A5988D83C9@IA1PR11MB6170.namprd11.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

We have a NMS application in cisco and using postgres as a database.

We have query related to disabling auto vacuum. We have below configuration in postgres.conf where the autovacuum=on is commented out.

[Shape Description automatically generated]

But when checked in database we notice that it’s showing as on

[Graphical user interface, timeline Description automatically generated]

What would this mean? Does it mean that autovacuum is not disabled? Appreciate a response.

Regards,
Karthik

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Hayato Kuroda (Fujitsu) 2022-11-07 11:42:53 RE: Perform streaming logical transactions by background workers and parallel apply
Previous Message Bharath Rupireddy 2022-11-07 11:23:35 Re: thinko in basic_archive.c