From: | "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net> |
---|---|
To: | Jeff Bohmer <jdblist(at)visionlink(dot)org> |
Cc: | Scott Marlowe <smarlowe(at)g2switchworks(dot)com>, Joe Maldonado <joe(dot)maldonado(at)gmail(dot)com>, pgsql-admin(at)postgresql(dot)org |
Subject: | Re: autovacuum daemon question... |
Date: | 2005-11-10 20:41:35 |
Message-ID: | 4373B07F.5040706@zeut.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Jeff Bohmer wrote:
>> I assumed (perhaps incorrectly) that you were talking about
>> maintaining the data in the theoretical / not yet in existence
>> autovacuum stats table through database restart, the stats system
>> already has a GUC var that dictates whether or not it dumps it's data
>> upon DB restart.
> AFAIK, a restart does not affect the VACUUMed-ness of anything.
> Keeping these (currently nonexistent autovacuum) stats across restarts
> would be helpful if stats_reset_on_server_start=on.
>
> Unless I misunderstand, if stats_reset_on_server_start=off, these
> (currently nonexistent autovacuum) stats would only be relevant for
> autovacuum's VACUUM activity and not it's ANALYZE activity. In which
> case, it seems ideal to keep autovacuum VACUUM stats regardless of the
> GUC setting, while autovacuum ANALYZE stats should follow it. But if
> the ideal is impractical, making both ANALYZE and VACUUM stats follow
> the GUC would still be real nice.
I'm confused... the GUC var stats_reset_on_server_start dictates if the
stats system dumps its data on DB restart. If we added a new table to
the stats system kept track of autovacuum activity, then that data would
also be dumped on restart if stats_reset_on_server_start=true.
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff Bohmer | 2005-11-10 20:50:22 | Re: autovacuum daemon question... |
Previous Message | Jeff Bohmer | 2005-11-10 20:21:30 | Re: autovacuum daemon question... |