I'v got a 220M db running under PgSQL 8.1 (upgrade not possible ATM.). If I do a reindex, the db size goes to 220 but then it starts growing over time (it shoudln't), a few megs per day.
I did progressively increase the autovacuum (enabled) daemon running frequence to reach finally those settings:
autovacuum = on
autovacuum_naptime = 25
autovacuum_vacuum_threshold = 40
autovacuum_analyze_threshold = 30
autovacuum_vacuum_scale_factor = 0.1
autovacuum_analyze_scale_factor = 0.05
This is even more than the recommended settings (default on a 8.4) but still, the database is growing.
And regarding the FSM (VACUUM VERBOSE output): INFO: free space map contains 2081 pages in 76 relations DETAIL: A total of 3088 page slots are in use (including overhead). 3088 page slots are required to track all free space. Current limits are: 20000 page slots, 1000 relations, using 222 KB.
So, I really don't know what should I do next in order to solve this database growing issue (beside upgrading), any though?