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
