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