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 Monnerie||Date: 2010-01-25 14:40:19|
|Subject: Re: max_fsm_pages question|
|Previous:||From: Kevin Grittner||Date: 2010-01-25 13:18:43|
|Subject: Re: how to speed ilike|