Re: Tables not getting vacuumed in postgres

From: Amul Sul <sulamul(at)gmail(dot)com>
To: "Karthik Jagadish (kjagadis)" <kjagadis(at)cisco(dot)com>
Cc: "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>, "Prasanna Satyanarayanan (prassaty)" <prassaty(at)cisco(dot)com>, "Chandruganth Ayyavoo Selvam (chaayyav)" <chaayyav(at)cisco(dot)com>, "Jaganbabu M (jmunusam)" <jmunusam(at)cisco(dot)com>
Subject: Re: Tables not getting vacuumed in postgres
Date: 2022-11-08 13:08:50
Message-ID: CAAJ_b944_RCc3N-F7=m5RiXt7TFd0YZ+LivWKsggH3Wr1uOLYA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Nov 8, 2022 at 6:11 PM Karthik Jagadish (kjagadis)
<kjagadis(at)cisco(dot)com> wrote:
>
> 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?
>

Well, yes, that won't interfere but the primary job of autovacuum is
to remove the bloat, if the dead tuple(s) is visible to any
transaction, then not going to remove that.

>
>
> Regards,
>
> Karthik
>
>
>
> From: Amul Sul <sulamul(at)gmail(dot)com>
> Date: Tuesday, 8 November 2022 at 5:38 PM
> To: Karthik Jagadish (kjagadis) <kjagadis(at)cisco(dot)com>
> Cc: pgsql-hackers(at)postgresql(dot)org <pgsql-hackers(at)postgresql(dot)org>, Prasanna Satyanarayanan (prassaty) <prassaty(at)cisco(dot)com>, Chandruganth Ayyavoo Selvam (chaayyav) <chaayyav(at)cisco(dot)com>, Jaganbabu M (jmunusam) <jmunusam(at)cisco(dot)com>
> Subject: Re: Tables not getting vacuumed in postgres
>
> On Tue, Nov 8, 2022 at 5:00 PM Karthik Jagadish (kjagadis)
> <kjagadis(at)cisco(dot)com> 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2022-11-08 13:14:14 Re: Check return value of pclose() correctly
Previous Message Karthik Jagadish (kjagadis) 2022-11-08 12:41:09 Re: Tables not getting vacuumed in postgres