Re: Tables not getting vacuumed in postgres

Поиск
Список
Период
Сортировка
От Amul Sul
Тема Re: Tables not getting vacuumed in postgres
Дата
Msg-id CAAJ_b94SbsiMg4FFgtqF8RHv2W4EM3fPeotySFpL+CwY1LffUQ@mail.gmail.com
обсуждение исходный текст
Ответ на Tables not getting vacuumed in postgres  ("Karthik Jagadish (kjagadis)" <kjagadis@cisco.com>)
Ответы Re: Tables not getting vacuumed in postgres
Список 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 по дате отправления:

Предыдущее
От: "Daniel Verite"
Дата:
Сообщение: Re: psql: Add command to use extended query protocol
Следующее
От: Bharath Rupireddy
Дата:
Сообщение: Re: when the startup process doesn't (logging startup delays)