Jack Orenstein <jack(dot)orenstein(at)hds(dot)com> 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