From: Robin Iddon <robin@edesix.com>
To: pgsql-admin@postgresql.org
Subject: Re: autovacuum
Date: Thu, 15 Jun 2006 12:20:19 +0100
Message-ID: <44914273.9030308@edesix.com> (raw)
In-Reply-To: <6992E470F12A444BB787B5C937B9D4DF04C4C928@ca-mail1.cis.local>
References: <6992E470F12A444BB787B5C937B9D4DF04C4C928@ca-mail1.cis.local>
> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: robin@edesix.com
Subject: Re: autovacuum
In-Reply-To: <44914273.9030308@edesix.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox