Hi, Thanks for the response.
But what I understand that insert update and delete would still work and will not interfere with vacuuming process. Yes we do perform a lot of updates on that particular table which is not vacuuming. Does it mean that it waiting for the lock to be released? Regards, Karthik From: Amul Sul <[email protected]> Date: Tuesday, 8 November 2022 at 5:38 PM To: Karthik Jagadish (kjagadis) <[email protected]> Cc: [email protected] <[email protected]>, Prasanna Satyanarayanan (prassaty) <[email protected]>, Chandruganth Ayyavoo Selvam (chaayyav) <[email protected]>, Jaganbabu M (jmunusam) <[email protected]> Subject: Re: Tables not getting vacuumed in postgres On Tue, Nov 8, 2022 at 5:00 PM Karthik Jagadish (kjagadis) <[email protected]> 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 out. > > What could be the reason for auto vacuuming not happening for certain tables? > Check if there is any long-running or prepared transaction. Regards, Amul
