| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Dave Cramer <pg(at)fastcrypt(dot)com> |
| Cc: | 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:45:38 |
| Message-ID: | 20080826174538.GP4920@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Dave Cramer wrote:
> On Tue, Aug 26, 2008 at 1:33 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> > Could we first see a cycle of autovac log output with
> > log_autovacuum_min_duration = 0?
> > Otherwise we're not going to get closer to understanding why it's
> > not cleaning up template0 for you.
>
> I actually set that last time I restarted. There's nothing particularly
> interesting there. Is there another log GUC that needs to be tweaked to get
> more output ?
My guess is that autovacuum is skipping the database for some reason, so
there's no log entry at all.
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Cramer | 2008-08-26 17:49:41 | Re: can't stop autovacuum by HUP'ing the server |
| Previous Message | Dave Cramer | 2008-08-26 17:44:03 | Re: can't stop autovacuum by HUP'ing the server |