Re: Postgresql selecting strange index for simple query

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Postgresql selecting strange index for simple query
Дата
Msg-id 18710.1235666038@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Postgresql selecting strange index for simple query  (Maxim Boguk <mboguk@masterhost.ru>)
Ответы Re: Postgresql selecting strange index for simple query  (Maxim Boguk <mboguk@masterhost.ru>)
Список 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 по дате отправления:

Предыдущее
От: Andrew Gould
Дата:
Сообщение: Re: Off Topic: ICD-10 codes in a database table?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Postgresql selecting strange index for simple query