Jim C. Nasby wrote: > On Tue, Aug 22, 2006 at 11:08:49AM -0400, Tom Lane wrote: >> "Jim C. Nasby" <[EMAIL PROTECTED]> writes: >>> If there's a bunch of activity on a table but stats are reset >>> before a vacuum is run on it and then a vacuum is run, the user >>> will still be left thinking that the table needs to be vacuumed. >> >> Except that autovac *won't* vacuum it if the stats have been reset. >> So I'm not seeing that there's really a problem in practice. > > IIRC the stats also include info about regular (manual) vacuums, so > the above scenario still applies.
They do. The stats patch as applied captures both autovacuum and manual vacuum as well as analyze (both from the Autovacuum daemon and manual). -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 512-248-2683 E-Mail: ler@lerctr.org US Mail: 430 Valona Loop, Round Rock, TX 78681-3893 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org