| From: | Scott Marlowe <smarlowe(at)g2switchworks(dot)com> |
|---|---|
| To: | Jeff Bohmer <jdblist(at)visionlink(dot)org> |
| Cc: | "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>, 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:18:01 |
| Message-ID: | 1131635881.3554.60.camel@state.g2switchworks.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Thu, 2005-11-10 at 02:04, Jeff Bohmer wrote:
> >Another thought: How about adding something to the stats system
> >that an admin can turn on / off. Maybe anew relation called
> >pg_stat_autovacuum_activity this would detail the last vacuum, last
> >analyze, number of vacuums / analyzes in the last 24 hours, last
> >month etc... I dunno, whatever peopel think is relevant.
> >
> >Thoughts?
>
>
> My 2c ...
>
> 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Matthew T. O'Connor | 2005-11-10 15:56:08 | Re: autovacuum daemon question... |
| Previous Message | Jyry Kuukkanen | 2005-11-10 09:58:25 | Re: how to merge two databases |