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



-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Reply via email to