Re: Tables not getting vacuumed in postgres

2022-11-08 Thread Mark Dilger
> On Nov 8, 2022, at 5:21 AM, Karthik Jagadish (kjagadis) > wrote: > > I didn’t get your point dead tuples are visible to transaction means? > Vacuuming job is to remove dead tuples right? Please see https://www.2ndquadrant.com/en/blog/when-autovacuum-does-not-vacuum/ for more information

Re: Tables not getting vacuumed in postgres

2022-11-08 Thread Karthik Jagadish (kjagadis)
) , Chandruganth Ayyavoo Selvam (chaayyav) , Jaganbabu M (jmunusam) Subject: Re: Tables not getting vacuumed in postgres On Tue, Nov 8, 2022 at 6:11 PM Karthik Jagadish (kjagadis) wrote: > > Hi, > > > > Thanks for the response. > > > > But what I understand that insert

Re: Tables not getting vacuumed in postgres

2022-11-08 Thread Amul Sul
ng to remove that. > > > Regards, > > Karthik > > > > From: Amul Sul > Date: Tuesday, 8 November 2022 at 5:38 PM > To: Karthik Jagadish (kjagadis) > Cc: pgsql-hack...@postgresql.org , Prasanna > Satyanarayanan (prassaty) , Chandruganth Ayyavoo Selvam > (chaayyav

Re: Tables not getting vacuumed in postgres

2022-11-08 Thread Karthik Jagadish (kjagadis)
? Regards, Karthik From: Amul Sul Date: Tuesday, 8 November 2022 at 5:38 PM To: Karthik Jagadish (kjagadis) Cc: pgsql-hack...@postgresql.org , Prasanna Satyanarayanan (prassaty) , Chandruganth Ayyavoo Selvam (chaayyav) , Jaganbabu M (jmunusam) Subject: Re: Tables not getting vacuumed in postgres On

Re: Tables not getting vacuumed in postgres

2022-11-08 Thread Amul Sul
On Tue, Nov 8, 2022 at 5:00 PM Karthik Jagadish (kjagadis) wrote: > > Hi, > > We have a NMS application where we are using postgres as database, what we > are noticing is that vacuuming is not happening for certain tables for 2-3 > days and eventually the table bloats and disk space is running o