Re: Tables not getting vacuumed in postgres
| От | Karthik Jagadish (kjagadis) |
|---|---|
| Тема | Re: Tables not getting vacuumed in postgres |
| Дата | |
| Msg-id | IA1PR11MB617053CD2979BE6EF83F9EB2D83F9@IA1PR11MB6170.namprd11.prod.outlook.com обсуждение исходный текст |
| Ответ на | Re: Tables not getting vacuumed in postgres (Amul Sul <sulamul@gmail.com>) |
| Ответы |
Re: Tables not getting vacuumed in postgres
|
| Список | pgsql-hackers |
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 <sulamul@gmail.com>
Date: Tuesday, 8 November 2022 at 5:38 PM
To: Karthik Jagadish (kjagadis) <kjagadis@cisco.com>
Cc: pgsql-hackers@postgresql.org <pgsql-hackers@postgresql.org>, Prasanna Satyanarayanan (prassaty) <prassaty@cisco.com>, Chandruganth Ayyavoo Selvam (chaayyav) <chaayyav@cisco.com>, Jaganbabu M (jmunusam) <jmunusam@cisco.com>
Subject: Re: Tables not getting vacuumed in postgres
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 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
В списке pgsql-hackers по дате отправления: