Re: AutoVaccuum process start as its off in potgresql.conf]

From: Tino Schwarze <postgresql(at)tisc(dot)de>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: AutoVaccuum process start as its off in potgresql.conf]
Date: 2008-11-27 15:49:35
Message-ID: 20081127154935.GB14973@easy2.in-chemnitz.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Fabricio 2008-11-27 16:45:47 Re: NUMA architecture and PostgreSQL
Previous Message Vishal Arora 2008-11-27 12:27:26 Re: PgAgent Job Scehduler is NOT running