"Alvaro Herrera" <[EMAIL PROTECTED]> writes: > Gregory Stark wrote: > > > is it possible it's related to the performance drop immediately > > following a vacuum analyze we've been seeing? > > I don't think so, unless you were counting on pgstats data of shared > tables for something. The optimizer, for one, doesn't, so I doubt it > would affect query planning. And it would only affect you if your > queries were using shared tables, which I very much doubt ...
Does anything use the pgstats data for anything other than presenting feedback to users? Autovacuum uses it to estimate when tables should be vacuumed right? This wouldn't have caused autovacuum to go nuts vacuuming these tables would it? But I doubt even then that it could consume much i/o bandwidth. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
