Details
-
Bug
-
Status: Resolved
-
Normal
-
Resolution: Fixed
-
None
-
PuppetDB
-
Customer Feedback
-
Major
-
Enhancement
-
Default auto-vacuum settings for several tables have been updated to match support's recommendations. These changes will apply (once) at the next upgrade.
-
Needs Assessment
Description
The Problem
Observing customer environments and our internal puppet deployment using pgbadger we see that various table gets VACUUMed far more frequently than necessary only removing a few hundred or thousand dead tuples per vacuum.
This can be improved by changing the percentage threshold after which postgresql thinks it should vacumm the tables.
To start with the factsets, catalogs, and certnames tables have the largest issue.