| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Chris Hoover <revoohc(at)gmail(dot)com> |
| Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: 8.1.3 - autovacuum question |
| Date: | 2006-06-26 20:59:30 |
| Message-ID: | 20060626205930.GC11926@surnet.cl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Chris Hoover wrote:
> I turned on autovacuum on one of my database servers over the weekend. I
> have been looking at the logs trying to see what it is doing. However, all
> I see are lines like this:
> ,7674,,2006-06-26 16:31:37.650 EDT,,1,,,,LOG: autovacuum: processing
> database "postgres"
>
> Is there a way to tell if autovacuum is actually doing any work?
Yeah, autovacuum is pretty stupid in its logging. You can put
log_min_messages (or min_log_messages, I always forget which one it is)
DEBUG2 to get more detailed messages. You'll get a lot other stuff as
well :-(
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jorge Portillo | 2006-06-26 20:59:49 | Installation in AIX 5.3 |
| Previous Message | Carlos H. Reimer | 2006-06-26 20:48:11 | RES: Hiding table structure information |