Re: Weird indices - Mailing list pgsql-general

From Tom Lane
Subject Re: Weird indices
Date
Msg-id 8890.982718508@sss.pgh.pa.us
Whole thread Raw
In response to Re: Weird indices  (Joseph Shraibman <jks@selectacast.net>)
List 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

pgsql-general by date:

Previous
From: Joseph Shraibman
Date:
Subject: Re: Weird indices
Next
From: Ian Lance Taylor
Date:
Subject: Re: Weird indices