Horton

Re: Weird indices

Joseph S <jks@selectacast.net>

View thread View on postgr.es
From: Joseph Shraibman <jks@selectacast.net>
To: Stephan Szabo <sszabo@megazone23.bigpanda.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, pgsql-general@postgresql.org
Date: 2001-02-21T00:55:45Z
Lists: pgsql-general 
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