Vacuum and FSM page size

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.

Responses

Browse pgsql-performance by date

  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