Re: Autovacuum on by default?

On Tue, Aug 22, 2006 at 11:08:49AM -0400, Tom Lane wrote:
> "Jim C. Nasby" <jim@nasby.net> 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.
-- 
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461