Re: temporarily stop autovacuum

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Tatsuo Ishii <ishii(at)postgresql(dot)org>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: temporarily stop autovacuum
Date: 2009-02-10 01:48:18
Message-ID: 1234230498.6517.105.camel@jd-laptop.pragmaticzealot.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, 2009-02-10 at 10:15 +0900, Tatsuo Ishii wrote:
> Hi,
>
> Is there any way to stop autovacuum temporarily?(other than edit
> postgresql.conf and reload it) Pgpool-II does not want autovacuum
> running while doing "onlie recovery".

It would be a significant hack but you could update pg_autovacuum to set
all relations to false.

Joshua D. Drake

> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
>
--
PostgreSQL - XMPP: jdrake(at)jabber(dot)postgresql(dot)org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tatsuo Ishii 2009-02-10 01:50:27 Re: temporarily stop autovacuum
Previous Message Tatsuo Ishii 2009-02-10 01:15:21 temporarily stop autovacuum