From: Tino Schwarze <postgresql@tisc.de>
To: pgsql-admin@postgresql.org
Subject: Re: AutoVaccuum process start as its off in potgresql.conf]
Date: Thu, 27 Nov 2008 16:49:35 +0100
Message-ID: <20081127154935.GB14973@easy2.in-chemnitz.de> (raw)
In-Reply-To: <492E1748.50408@synechron.com>
References: <492E1748.50408@synechron.com>
On Thu, Nov 27, 2008 at 09:13:04AM +0530, AmitKumar Jain wrote:
> I am using PostgreSQL 8.3 version . The autovacuum process is stucking
> my system as it automtically start even though its off is
> postgresql.conf.
>
> 2. Is there any benchmark tool for Autovacuum process or can we know how
> much time this proces will take to complete?
If the autovacuum process kicks in even if it is disabled, you database
is in danger of XID wraparound! You should check your vacuum policy
(e.g. if it covers all of your databases and tables, including the
system databases).
Tino.
--
"What we nourish flourishes." - "Was wir nähren erblüht."
www.lichtkreis-chemnitz.de
www.craniosacralzentrum.de
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: postgresql@tisc.de
Subject: Re: AutoVaccuum process start as its off in potgresql.conf]
In-Reply-To: <20081127154935.GB14973@easy2.in-chemnitz.de>
* 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