Re: More logging for autovacuum

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Gregory Stark <stark(at)enterprisedb(dot)com>
Cc: PostgreSQL-development Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: More logging for autovacuum
Date: 2007-08-17 22:14:20
Message-ID: 20070817221420.GH5605@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Gregory Stark wrote:
>
> I'm having trouble following what's going on with autovacuum and I'm finding
> the existing logging insufficient. In particular that it's only logging vacuum
> runs *after* the vacuum finishes makes it hard to see what vacuums are running
> at any given time. Also, I want to see what is making autovacuum decide to
> forgo vacuuming a table and the log with that information is at DEBUG2.

So did this idea go anywhere?

--
Alvaro Herrera Developer, http://www.PostgreSQL.org/
Officer Krupke, what are we to do?
Gee, officer Krupke, Krup you! (West Side Story, "Gee, Officer Krupke")

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Ron Mayer 2007-08-17 22:32:54 Re: tsearch2 in PostgreSQL 8.3?
Previous Message Alvaro Herrera 2007-08-17 22:00:44 Re: Problem with locks