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: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
Michael Monnerie  wrote:
> why did postgres suddenly decide to remove the old cruft suddenly?
Have you read through this yet?:
> 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.


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-2017 The PostgreSQL Global Development Group