Tables not getting vacuumed in postgres

Поиск
Список
Период
Сортировка
От Karthik Jagadish (kjagadis)
Тема Tables not getting vacuumed in postgres
Дата
Msg-id IA1PR11MB6170233F8351898E273AFDF9D83F9@IA1PR11MB6170.namprd11.prod.outlook.com
обсуждение исходный текст
Ответы Re: Tables not getting vacuumed in postgres
Список pgsql-hackers

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?

Autovacuum is enabled 

Regards,
Karthik 

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: refactor ownercheck and aclcheck functions
Следующее
От: Andrey Lepikhov
Дата:
Сообщение: Re: [PoC] Reducing planning time when tables have many partitions