Postgres Pro
Downloads
Home   >   mailing lists

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

From Karthik Jagadish (kjagadis)
Subject Tables not getting vacuumed in postgres
Date
Msg-id IA1PR11MB6170233F8351898E273AFDF9D83F9@IA1PR11MB6170.namprd11.prod.outlook.com
Whole thread Raw
Responses Re: Tables not getting vacuumed in postgres
List pgsql-hackers
Tree view

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 by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: refactor ownercheck and aclcheck functions
Next
From: Andrey Lepikhov
Date:
Subject: Re: [PoC] Reducing planning time when tables have many partitions