Re: Tables not getting vacuumed in postgres - Mailing list pgsql-hackers

From Amul Sul
Subject Re: Tables not getting vacuumed in postgres
Date
Msg-id CAAJ_b94SbsiMg4FFgtqF8RHv2W4EM3fPeotySFpL+CwY1LffUQ@mail.gmail.com
Whole thread Raw
In response to Tables not getting vacuumed in postgres  ("Karthik Jagadish (kjagadis)" <kjagadis@cisco.com>)
Responses Re: Tables not getting vacuumed in postgres
List pgsql-hackers
On Tue, Nov 8, 2022 at 5:00 PM Karthik Jagadish (kjagadis)
<kjagadis@cisco.com> wrote:
>
> Hi,
>
> We have a NMS application where we are using postgres as database, what we are noticing is that vacuuming is not
happeningfor 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



pgsql-hackers by date:

Previous
From: "Daniel Verite"
Date:
Subject: Re: psql: Add command to use extended query protocol
Next
From: Bharath Rupireddy
Date:
Subject: Re: when the startup process doesn't (logging startup delays)