Matthew T. O'Connor wrote: > Tom Lane wrote: > >Yeah, I was concerned about that when I was making the patch, but didn't > >see any simple fix. A large number of DELETEs (without any inserts or > >updates) would trigger a VACUUM but not an ANALYZE, which in the worst > >case would be bad because the stats could have shifted. > > > >We could fix this at the cost of carrying another per-table counter in > >the stats info, but I'm not sure it's worth it. > > I believe that whenever autovacuum performs a VACUUM it actually > performs a VACUUM ANALYZE at leas the old contrib version did and I > think Alvaro copied that.
Huh, no, it doesn't --- they are considered separately. -- Alvaro Herrera Valdivia, Chile ICBM: S 39º 49' 18.1", W 73º 13' 56.4" "La rebeldía es la virtud original del hombre" (Arthur Schopenhauer) ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
