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
