Message-ID: <44914273.9030308@edesix.com>
Date: Thu, 15 Jun 2006 12:20:19 +0100
From: Robin Iddon <robin@edesix.com>
User-Agent: Thunderbird 1.5.0.4 (Windows/20060516)
MIME-Version: 1.0
To: pgsql-admin@postgresql.org
Subject: Re: autovacuum
References: <6992E470F12A444BB787B5C937B9D4DF04C4C928@ca-mail1.cis.local>
In-Reply-To: <6992E470F12A444BB787B5C937B9D4DF04C4C928@ca-mail1.cis.local>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit


> How do I know if autovacuum is reclaiming space or is my max_fsm setting
> plain wrong. (I understand that autovacuum marks tuples for reuse, but
> shouldn't pg_total_relation_size take that into account)
>   
You can find out if your FSM settings are big enough by running vacuumdb
-av (and yes, it needs to be -a) - obviously you might choose not to run
this when the database is busy doing something else.

Capture the output - at the very end it will tell you whether or not
your FSM settings are adequate to map the reusable space in the database.

You might also want to read the documentation on autovacuum's logging
output options - this may tell you what you want to know - prior to 8.1
autovacuum was documented in (on my system)
/usr/doc/postgres-x.x.x/contrib/README.pg_autovacuum - post 8.1 it's
part of the main distribution and should be documented in the main PG docs.

Hope this helps,
Robin