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.
Jim C. Nasby, Sr. Engineering Consultant      [EMAIL PROTECTED]
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Reply via email to