Re: why is autovacuum still ongoing even if set to off ?

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Costin Grigoras <costing(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: why is autovacuum still ongoing even if set to off ?
Date: 2009-07-31 00:00:48
Message-ID: dcc563d10907301700r7cb87771g7a32613eb08e25a@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Jul 30, 2009 at 2:52 PM, Costin Grigoras<costing(at)gmail(dot)com> wrote:
> Hi,
>
> I'm running 8.4 and I've tried to disable autovacuum since the vacuuming is
> taken care internally in the code. The same was true with the previous
> version (8.0 to 8.3) and there was never any problem. However now in 8.4 the
> "off" setting seems to be ignored even if "track_counts = off" and huge
> naptime and thresholds are set. For example this is in the logs:

The only thing I can think of is the automatic kickoff of autovacuum
to prevent transaction wraparound.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Daniel Verite 2009-07-31 01:02:07 Re: pg_config --sharedir points to the wrong folder.. is this a problem?
Previous Message Devrim GÜNDÜZ 2009-07-30 21:58:16 Re: SVN and Postgres 8.3