Our database has about 70 tables. Only a half-dozen or so have more
than 100K rows, and all of these change (99% inserts, 10K-50K rows)
during an average day.
VACUUM ANALYZE takes over an hour, and it's edging up by a couple
minutes per day.
Is there a way to look at the DEBUG stats from the VACUUM command
(written to the postmaster log) to determine what the optimum interval
would be between VACUUMs? (Perhaps I could do three of the "big"
tables on odd-numbered days, and the rest on even-numbered days?)
