Re: Autovacuum Issue - Mailing list pgsql-performance

From Robert Haas
Subject Re: Autovacuum Issue
Date
Msg-id CA+TgmobPwvrHXgBYHPcY9jFpaTumGaMHi-vMTm5hFLVxircQGw@mail.gmail.com
Whole thread Raw
In response to Autovacuum Issue  (J Ramesh Kumar <rameshj1977@gmail.com>)
Responses Re: Autovacuum Issue  (Mark Kirkwood <mark.kirkwood@catalyst.net.nz>)
List pgsql-performance
On Wed, Nov 23, 2011 at 12:55 AM, J Ramesh Kumar <rameshj1977@gmail.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

pgsql-performance by date:

Previous
From: Josh Berkus
Date:
Subject: Re: vacuum internals and performance affect
Next
From: MirrorX
Date:
Subject: Re: vacuum internals and performance affect