On Jun19, 2011, at 23:16 , Robert Haas wrote: > 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%.
Hm, so you could ignore (or rather dampen) the results of VACUUM+ANALYZE and rely on the ANALYZE-only runs to keep the estimate correct. Still doesn't sound that bad... best regards, Florian Pflug -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
