Horton

Re: Second attempt, roll your own autovacuum

Alvaro Herrera <alvherre@commandprompt.com>

View thread
From: Alvaro Herrera <alvherre@commandprompt.com>
To: Glen Parker <glenebob@nwlink.com>
Cc: Postgres General <pgsql-general@postgresql.org>
Date: 2006-12-18T21:52:53Z
Lists: pgsql-hackers 
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