From: | "Thomas Lozza" <thomas(dot)lozza(at)nexustelecom(dot)com> |
---|---|
To: | <pgsql-performance(at)postgresql(dot)org> |
Subject: | Vacuum and FSM page size |
Date: | 2008-01-23 18:29:16 |
Message-ID: | F6B04D920899DF47B1E1A4F40415167E3D4299@gaia.nexus-ag.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
hi
We have an installation of Postgres 8.1.2 (32bit on Solaris 9) with a DB
size of about 250GB on disk. The DB is subject to fair amount of
inserts, deletes and updates per day.
Running VACUUM VERBOSE tells me that I should allocate around 20M pages
to FSM (max_fsm_pages)! This looks like a really large amount to me.
Has anyone gone ever that high with max_fsm_pages?
The other question is why such a large number is required in the first
place.
Auto vacuum is enabled. Here are the settings:
autovacuum = true
autovacuum_naptime = 900
autovacuum_vacuum_threshold = 2000
autovacuum_analyze_threshold = 1000
autovacuum_vacuum_scale_factor = 0.25
autovacuum_analyze_scale_factor = 0.18
autovacuum_vacuum_cost_delay = 150
autovacuum_vacuum_cost_limit = 120
A manual vacuum takes very long (around 4 days), so maybe the cost delay
and limit or too high.
Any suggestions anyone?
Cheers,
-- Tom.
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Marlowe | 2008-01-23 18:44:38 | Re: Making the most of memory? |
Previous Message | Tory M Blue | 2008-01-23 18:23:51 | Postgres 8.2 memory weirdness |