On Sun, Jun 19, 2011 at 5:10 PM, Florian Pflug <f...@phlo.org> wrote: > On Jun19, 2011, at 20:40 , Robert Haas wrote: >> 2. Since VACUUM and ANALYZE often run together, we will be estimating >> the percentage of rows on all-visible pages just at the time when that >> percentage is highest. This is not exactly wonderful, either... > > Hm, doesn't autovacuum run ANALYZE quite a bit more frequently than > VACUUM by default?
The autoanalyze threshold is, by default, 10%; and the autovacuum threshold, 20%. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (email@example.com) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers