Postgres Pro
Downloads
Home   >   mailing lists

Re: Second attempt, roll your own autovacuum - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Second attempt, roll your own autovacuum
Date
Msg-id 20061218215253.GO12526@alvh.no-ip.org
Whole thread Raw
In response to Second attempt, roll your own autovacuum  (Glen Parker <glenebob@nwlink.com>)
Responses Re: Second attempt, roll your own autovacuum  (Glen Parker <glenebob@nwlink.com>)
List pgsql-general
Tree view 
Glen Parker wrote:

> The trouble now is, I don't see how to reset the statistics.  My
> assumption was that vacuum did it, but that appears to be false.  How
> does autovacuum do it?  Can I do it with SQL?

Huh, reset what statistics?  Autovacuum does not reset anything.  What
statistics are you using?  The number of dead tuples _should_ show as
zero on the stat system after a vacuum, certainly.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-general by date:

Previous
From: Jeff Davis
Date:
Subject: Re: feature request for Postgresql Rule system.
Next
From: "semi-ambivalent"
Date:
Subject: Changes in 8.2's PHP behaviour?