From: Alvaro Herrera <alvherre@commandprompt.com>
To: Gnanakumar <gnanam@zoniac.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Autovacuum daemon functionality questions
Date: Thu, 8 Apr 2010 10:53:28 -0400
Message-ID: <20100408145328.GB4126@alvh.no-ip.org> (raw)
In-Reply-To: <00c001cad728$22f92f20$68eb8d60$@com>
References: <00c001cad728$22f92f20$68eb8d60$@com>
Gnanakumar wrote:
> 1. Why need to have 2 parameters (base threshold and scale factor) to define
> the threshold value, when either one of the parameter is more than enough to
> define the threshold value. Can you explain the significance of having both
> parameters. What is the real-time advantage of this?
real-time advantage? They are just the two factors in a linear
equation.
> 2. Documentation says ".... If the number of obsolete tuples since the last
> VACUUM exceeds the "vacuum threshold", the table is vacuumed ...".
> I also know about this table "pg_stat_user_tables" which has columns
> n_tup_ins, n_tup_upd, n_tup_del, last_autovaccum and last_autoanalyze.
> Since INSERT, UPDATE and DELETE count gets incremented everytime and do not
> reset after running autovacuum/autoanalyze, how does autovacuum identifies
> obsolete tuples since last VACUUM from this entries.
There are two separate counters for live and dead tuples, IIRC (though
they may not be exposed in the pg_stat views)
> 3. Is there a way to see autovacuum daemon log entries?
Not in 8.2.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: alvherre@commandprompt.com, gnanam@zoniac.com
Subject: Re: Autovacuum daemon functionality questions
In-Reply-To: <20100408145328.GB4126@alvh.no-ip.org>
References: <00c001cad728$22f92f20$68eb8d60$@com> <20100408145328.GB4126@alvh.no-ip.org>
* 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