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?) ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
