Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group