| 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: | Whole Thread | Raw Message | 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 |