Re: Postgresql selecting strange index for simple query - Mailing list pgsql-general

From Tom Lane
Subject Re: Postgresql selecting strange index for simple query
Date
Msg-id 18710.1235666038@sss.pgh.pa.us
Whole thread Raw
In response to Re: Postgresql selecting strange index for simple query  (Maxim Boguk <mboguk@masterhost.ru>)
Responses Re: Postgresql selecting strange index for simple query  (Maxim Boguk <mboguk@masterhost.ru>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Andrew Gould
Date:
Subject: Re: Off Topic: ICD-10 codes in a database table?
Next
From: Tom Lane
Date:
Subject: Re: Postgresql selecting strange index for simple query