Re: Postgres auto vacuum - Disable - Mailing list pgsql-hackers
Hi
On Mon, 7 Nov 2022 at 11:42, Karthik Jagadish (kjagadis) <kjagadis@cisco.com> wrote:
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.
But when checked in database we notice that it’s showing as on
What would this mean? Does it mean that autovacuum is not disabled? Appreciate a response.
Right. The default is for it to be enabled, so commenting out the option does nothing. You would need to set it explicitly to off.
BUT... you almost certainly don't want to do that. Cases where it should be disabled are *extremely* rare. Make sure you *really* know what you're letting yourself in for by disabling autovacuum, and don't rely on 10+ year old performance tuning advice from random places on the internet, if that's what you're doing.
Attachment
pgsql-hackers by date: