Alvaro Herrera wrote:
> 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.
pg_stat_user_tables.[n_tup_ins|n_tup_upd|n_tup_del]. Hmm maybe I'm
doing this all wrong then. Is there a way to find the estimated dead
tuples from SQL, the same number autovacuum looks at?
-Glen