Re: Why pgAdmin III guru suggests VACUUM in 8.1 - Mailing list pgsql-general

From Andrus
Subject Re: Why pgAdmin III guru suggests VACUUM in 8.1
Date
Msg-id dm21ue$1ncp$2@news.hub.org
Whole thread Raw
In response to Why pgAdmin III guru suggests VACUUM in 8.1  ("Andrus Moor" <eetasoft@online.ee>)
List pgsql-general
> I agree that the "processing database" message isn't too exciting, but
> it seems that forcing per-table messages up to LOG level would create
> even more log clutter.  I could support "processing table" at level
> DEBUG1 and "processing database" at DEBUG2.  Or maybe we should think
> harder about the idea recently mentioned of letting the autovacuum
> process have its own log-level setting, separate from ordinary backends'
> setting.

I would be helpful that the message gives the result also, like

23 tables in database 'foo' processed, 45 tables skipped,  12345 dead tuples
removed in 45 seconds

Andrus.



pgsql-general by date:

Previous
From: "Andrus"
Date:
Subject: Re: Why pgAdmin III guru suggests VACUUM in 8.1
Next
From: "codeWarrior"
Date:
Subject: Re: Strugging with NEW and OLD records.