Re: Why pgAdmin III guru suggests VACUUM in 8.1

From: "Andrus" <eetasoft(at)online(dot)ee>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Why pgAdmin III guru suggests VACUUM in 8.1
Date: 2005-11-23 15:01:49
Message-ID: dm21ue$1ncp$2@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andrew J. Kopciuch 2005-11-23 15:21:38 Re: tsearch2: more than one index per table?
Previous Message Andrus 2005-11-23 14:56:58 Re: Why pgAdmin III guru suggests VACUUM in 8.1