Hi List, We are running a couple of 8.3.1 servers and the are growing a lot.
I have the standard autovacuum settings from the 8.3.1 installation and we are inserting about 2-3 million rows every night and cleaning out just as many every day.
The database size rose to 80GB but after a dump/restore its only 16GB which shows that there where nearly 65GB bloat in the database.
#autovacuum_max_workers = 3 #autovacuum_naptime = 1min #autovacuum_vacuum_threshold = 50 #autovacuum_analyze_threshold = 50 #autovacuum_vacuum_scale_factor = 0.2 #autovacuum_analyze_scale_factor = 0.1 #autovacuum_freeze_max_age = 200000000 #autovacuum_vacuum_cost_delay = 20 #autovacuum_vacuum_cost_limit = -1 And also max_fsm_pages = 300000 #max_fsm_relations = 1000 Any pointers would be greatly appreciated. Cheers, Henke -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
