Skip site navigation (1) Skip section navigation (2)

Re: can't stop autovacuum by HUP'ing the server

From: Joshua Drake <jd(at)commandprompt(dot)com>
To: "Dave Cramer" <pg(at)fastcrypt(dot)com>
Cc: "Alvaro Herrera" <alvherre(at)commandprompt(dot)com>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: can't stop autovacuum by HUP'ing the server
Date: 2008-08-26 17:25:37
Message-ID: 20080826102537.1821f3a0@jd-laptop (view raw or flat)
Thread:
Lists: pgsql-hackers
On Tue, 26 Aug 2008 12:58:59 -0400
"Dave Cramer" <pg(at)fastcrypt(dot)com> wrote:

> 
> Well, I'm willing to help debug this, however this is a busy
> production database and I need to be able to turn it off for a few
> hours a day. Would changing autovacuum_freeze_max_age be a solution ?

Populate the table pg_autovacuum with all your relations and the
defaults from the postgresql.conf. Then set enabled to FALSE on all the
tuples. When you are ready to turn autovacuum back on, set it to TRUE.

Joshua D. Drake



-- 
The PostgreSQL Company since 1997: http://www.commandprompt.com/ 
PostgreSQL Community Conference: http://www.postgresqlconference.org/
United States PostgreSQL Association: http://www.postgresql.us/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate



In response to

pgsql-hackers by date

Next:From: Alvaro HerreraDate: 2008-08-26 17:29:21
Subject: Re: can't stop autovacuum by HUP'ing the server
Previous:From: Brendan JurdDate: 2008-08-26 17:22:03
Subject: Re: Split up the wiki TODO page?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group