From: | Henrik <henke(at)mac(dot)se> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Database growing. Need autovacuum help. |
Date: | 2008-06-03 11:55:24 |
Message-ID: | E38EA191-9A5F-4C41-9D93-26210F201E4A@mac.se |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Ivan Zolotukhin | 2008-06-03 12:03:01 | Re: Cannot drop user (PostgreSQL 8.1.11) |
Previous Message | Ram Ravichandran | 2008-06-03 11:48:12 | Re: turning fsync off for WAL |