pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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



view thread (4+ messages)  latest in thread

Message-ID: <20100408145328.GB4126@alvh.no-ip.org>
Permalink:  ../20100408145328.GB4126@alvh.no-ip.org/
Also on:    postgresql.org/message-id/20100408145328.GB4126@alvh.no-ip.org

 · 

reply

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