On Sun, Jun 19, 2011 at 5:10 PM, Florian Pflug <fgp@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