Re: Vacuuming anything zeroes shared table stats - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Vacuuming anything zeroes shared table stats
Date
Msg-id 20070607185953.GD21004@alvh.no-ip.org
Whole thread Raw
In response to Re: Vacuuming anything zeroes shared table stats  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
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)


pgsql-hackers by date:

Previous
From: Greg Smith
Date:
Subject: Re: Controlling Load Distributed Checkpoints
Next
From: Alvaro Herrera
Date:
Subject: Re: [PATCHES] [BUGS] BUG #3326: Invalid lower bound of autovacuum_cost_limit