| From: | Jeff Bohmer <jdblist(at)visionlink(dot)org> |
|---|---|
| To: | "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>, Scott Marlowe <smarlowe(at)g2switchworks(dot)com> |
| Cc: | 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:21:30 |
| Message-ID: | p06230914bf995bb6a436@[192.168.1.200] |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
>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.
Sorry, got the meaning backwards. The above should be
stats_reset_on_server_start=OFF. And the below should be the
opposite, too.
>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.
--
Jeff Bohmer
VisionLink, Inc.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Matthew T. O'Connor | 2005-11-10 20:41:35 | Re: autovacuum daemon question... |
| Previous Message | Jeff Bohmer | 2005-11-10 20:06:37 | Re: autovacuum daemon question... |