> 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
) , 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
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
?
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
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
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 tab