| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2008-08-26 17:29:21 | Re: can't stop autovacuum by HUP'ing the server |
| Previous Message | Brendan Jurd | 2008-08-26 17:22:03 | Re: Split up the wiki TODO page? |