Re: max_fsm_pages question

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: <michael(dot)monnerie(at)is(dot)it-management(dot)at>, <pgsql-admin(at)postgresql(dot)org>
Subject: Re: max_fsm_pages question
Date: 2010-01-25 13:24:54
Message-ID: 4B5D4746020000250002EB59@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Michael Monnerie wrote:

> why did postgres suddenly decide to remove the old cruft suddenly?

Have you read through this yet?:

http://www.postgresql.org/docs/8.3/interactive/runtime-config-resource.html#RUNTIME-CONFIG-RESOURCE-FSM

> Autovacuum is on, the nightly backups do an extra "vacuum analyze",
> and once a week a CLUSTER is done for the big tables.

You should probably make that a "vacuum analyze verbose" to get a
good idea of where you should set max_fsm_pages, and to look for
where you are accumumlating free space to track.

-Kevin

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Michael Monnerie 2010-01-25 14:40:19 Re: max_fsm_pages question
Previous Message Kevin Grittner 2010-01-25 13:18:43 Re: how to speed ilike