Re: autovacuum daemon question...

From: "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>
To: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>
Cc: Jeff Bohmer <jdblist(at)visionlink(dot)org>, Joe Maldonado <joe(dot)maldonado(at)gmail(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: autovacuum daemon question...
Date: 2005-11-10 15:56:08
Message-ID: 43736D98.5060205@zeut.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Scott Marlowe wrote:
>> I would appreciate an easy way to keep tabs on autovacuum's activity.
>> A stat table seems like a practical way to have this info readily
>> available.
>>
>> No need to keep values across dump/reloads, right?
>>
>
> This sounds more and more like a good idea. I don't think there's any
> need to maintain across dump/reload and / or database restart either.

The DBA can elect to keep or discard stats data across DB restart, in
fact I think the default value for this GUC var was set to true for the
8.1 release.

Matt

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Marlowe 2005-11-10 16:03:17 Re: autovacuum daemon question...
Previous Message Scott Marlowe 2005-11-10 15:18:01 Re: autovacuum daemon question...