Jack Orenstein <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> If you plug in a value that *does* occur in the table it should probably
>> choose the more-relevant index consistently.
> Unfortunately, it matters a lot at runtime. The dh value is not very
> selective,
> as shown by the statistics above.
A dh value that does not occur in the index is *perfectly* selective.
I'm not sure what your problem is but this example isn't illustrating
anything wrong that I can see.
regards, tom lane
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
