Tom Lane wrote: > Michael Fuhr <[EMAIL PROTECTED]> 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) ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org