Horton

Re: Weird indices

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Joseph Shraibman <jks@selectacast.net>
Cc: Stephan Szabo <sszabo@megazone23.bigpanda.com>, pgsql-general@postgresql.org
Date: 2001-02-21T01:21:48Z
Lists: pgsql-general 
Joseph Shraibman <jks@selectacast.net> writes:
> Then it should do the same thing no matter what value I use, but when I
> do different searches in one case it estimates 50 when there are 16 and
> in the other it estimeates 502 where there are 502.

Well, it does know the difference between searching for the most common
value and searching for other values, but whether that's relevant to
your example is impossible to say with no details.

			regards, tom lane