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.
