Re: Weird indices

Stephan Szabo wrote:

> Where are you seeing something that says the estimator/planner using the
> index to get an upper bound?  The estimator shouldn't be asking either the
> index or the heap for anything, it should be working entirely with the
> statistics that were generated from vacuum.

Index Scan using usertable_p_key on usertable  (cost=0.00..25.68 rows=50
width=72)

That rows=50, which is an overestimate by the way.

--
Joseph Shraibman
jks@selectacast.net
Increase signal to noise ratio.  http://www.targabot.com