Re: Postgresql selecting strange index for simple query

Maxim Boguk <mboguk@masterhost.ru> writes:
> Tom Lane wrote:
>> It does know better than that.  I'm wondering if the single-column index
>> has become very bloated or something.  Have you compared the physical
>> index sizes?

> Table fresh loaded from dump on test server... So no index bloat for sure...
> As for comparing physical sizes, right single column index indeed smaller then wrong one:

Huh.  I get sane-looking choices when I try a similar case here.  Can
you put together a self-contained test case?

            regards, tom lane