From: | Dave Page <dpage(at)pgadmin(dot)org> |
---|---|
To: | "Karthik Jagadish (kjagadis)" <kjagadis(at)cisco(dot)com> |
Cc: | "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>, "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: | Re: Postgres auto vacuum - Disable |
Date: | 2022-11-07 11:47:09 |
Message-ID: | CA+OCxoyRy2w9WFq=1390_igmkw+JeFSFkPi9GqFJe31guarg5Q@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi
On Mon, 7 Nov 2022 at 11:42, Karthik Jagadish (kjagadis) <kjagadis(at)cisco(dot)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.
>
>
>
> [image: Shape Description automatically generated]
>
>
>
> But when checked in database we notice that it’s showing as on
>
>
>
> [image: Graphical user interface, timeline Description automatically
> generated]
>
>
>
> 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.
--
Dave Page
Blog: https://pgsnake.blogspot.com
Twitter: @pgsnake
From | Date | Subject | |
---|---|---|---|
Next Message | Karthik Jagadish (kjagadis) | 2022-11-07 12:12:14 | Re: Postgres auto vacuum - Disable |
Previous Message | Hayato Kuroda (Fujitsu) | 2022-11-07 11:42:53 | RE: Perform streaming logical transactions by background workers and parallel apply |