Re: Postgres auto vacuum - Disable
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.
Вложения
В списке pgsql-hackers по дате отправления:
Предыдущее
От: "Hayato Kuroda (Fujitsu)"Дата:
Сообщение: RE: Perform streaming logical transactions by background workers and parallel apply