Database growing. Need autovacuum help.

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

Responses

Browse pgsql-general by date

  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