Tom Lane wrote:
> Michael Fuhr <mike@fuhr.org> writes:
> > Further investigation shows that what really seems to be happening
> > in 8.3devel is that the statistics for shared tables are reset every
> > 15 seconds when autovacuum is enabled, which it is by default. I
> > don't observe this phenomenon when autovacuum is disabled.
>
> OK, so it's just that pgstat_vacuum_tabstat() gets run by autovacuum.
> So either form of Alvaro's patch should fix it.
Right. Committed.
Thanks for the report!
--
Alvaro Herrera Developer, http://www.PostgreSQL.org/
"El miedo atento y previsor es la madre de la seguridad" (E. Burke)