On our database of about 5GB we vaccuum all of our 12 tables (only one
is huge, all others have about 100,000 rows or so) every hour or so.
But we also have autovaccuum enabled. Is this okay? Do the two vaccuum
processes contradict each other, or add unnecessary load to the
system?
The reason we introduced the cronjob we felt was that the autovaccuum
was not really doing its job. I wonder if anyone can share some
insight on whether these settings are good for a DB that is basically
24x7:
autovacuum = on
autovacuum_vacuum_cost_delay = 20
vacuum_cost_delay = 20
autovacuum_naptime = 10
stats_start_collector = on
stats_row_level = on
autovacuum_vacuum_threshold = 75
autovacuum_analyze_threshold = 25
autovacuum_analyze_scale_factor = 0.02
autovacuum_vacuum_scale_factor = 0.01
Thanks! I've read up some websites for this kind of tuning, but often
the info is for older versions of DBs and some of the tweaks have
changed since. I am on 8.2.9.