Jack Orenstein <jack.orenstein@xxxxxxx> 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 (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
