On Mar 31, 2007, at 5:15 PM, Martijn van Oosterhout wrote:
Firstly, with autovacuum you really don't need to be running VACUUM FULL anyway. VACUUM FULL is actually quite inefficient, you're better off having higher FSM settings and leaving it to autovacuum.
Thank you (and Bill Moran) for the response. The reason we run VACUUM FULL daily, I think, is just a hangover from the times when Postgres didn't have autovacuum in core. And I think using FULL in particular was from a desire to keep the database as trim as possible.
We'll flip our automated process off and see how things go. Maybe implement a monthly CLUSTER and/or REINDEX on the largest tables to help keep their sizes in check.
Thanks again! eric
