Re: Autovacuum Issue

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: J Ramesh Kumar <rameshj1977(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Autovacuum Issue
Date: 2011-12-01 18:18:53
Message-ID: CA+TgmobPwvrHXgBYHPcY9jFpaTumGaMHi-vMTm5hFLVxircQGw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Wed, Nov 23, 2011 at 12:55 AM, J Ramesh Kumar <rameshj1977(at)gmail(dot)com> wrote:
> Why the autovacuum is running even though, I disabled ? Am I miss anything ?

As Raghavendra says, anti-wraparound vacuum will always kick in to
prevent a database shutdown.

> And also please share your views on my decision about disable autovacuum for
> my application. I am planning to run vacuum command daily on that small
> table which has frequent updates.

Sounds like a bad plan.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message MirrorX 2011-12-01 19:23:56 Re: vacuum internals and performance affect
Previous Message Josh Berkus 2011-12-01 18:01:57 Re: vacuum internals and performance affect