Postgres Pro
Downloads
Home   >   mailing lists

Re: the big picture for index-only scans - Mailing list pgsql-hackers

From Florian Pflug
Subject Re: the big picture for index-only scans
Date
Msg-id 2D8C549E-00CF-4DFD-BF1F-C70E3369CB87@phlo.org
Whole thread Raw
In response to Re: the big picture for index-only scans  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: the big picture for index-only scans
List pgsql-hackers
Tree view 
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?

best regards,
Florian Pflug

pgsql-hackers by date:

Previous
From: Florian Pflug
Date:
Subject: Re: Adding a distinct "pattern" type to resolve the "~" commutator stalemate
Next
From: Simon Riggs
Date:
Subject: Re: ALTER TABLE lock strength reduction patch is unsafe