Re: Postgres auto vacuum - Disable

2022-11-07 Thread Karthik Jagadish (kjagadis)
Ayyavoo Selvam (chaayyav) , Prasanna Satyanarayanan (prassaty) , Jaganbabu M (jmunusam) , Joel Mariadasan (jomariad) Subject: Re: Postgres auto vacuum - Disable Hi, On Mon, Nov 07, 2022 at 02:22:56PM +0100, Laurenz Albe wrote: > On Mon, 2022-11-07 at 12:12 +, Karthik Jagadish (kjaga

Re: Postgres auto vacuum - Disable

2022-11-07 Thread Julien Rouhaud
Hi, On Mon, Nov 07, 2022 at 02:22:56PM +0100, Laurenz Albe wrote: > On Mon, 2022-11-07 at 12:12 +, Karthik Jagadish (kjagadis) wrote: > > I have follow-up question where the vacuum process is waiting and not doing > > it’s job. > > When we grep on waiting process we see below output.

Re: Postgres auto vacuum - Disable

2022-11-07 Thread Laurenz Albe
On Mon, 2022-11-07 at 12:12 +, Karthik Jagadish (kjagadis) wrote: > I have follow-up question where the vacuum process is waiting and not doing > it’s job. > When we grep on waiting process we see below output. Whenever we see this we > notice > that the vacuum is not happening and the

Re: Postgres auto vacuum - Disable

2022-11-07 Thread Karthik Jagadish (kjagadis)
) , Joel Mariadasan (jomariad) Subject: Re: Postgres auto vacuum - Disable Hi On Mon, 7 Nov 2022 at 11:42, Karthik Jagadish (kjagadis) mailto:kjaga...@cisco.com>> wrote: Hi, We have a NMS application in cisco and using postgres as a database. We have query related to disabling auto vacu

Re: Postgres auto vacuum - Disable

2022-11-07 Thread Dave Page
Hi On Mon, 7 Nov 2022 at 11:42, Karthik Jagadish (kjagadis) 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.

Postgres auto vacuum - Disable

2022-11-07 Thread Karthik Jagadish (kjagadis)
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