Re: Slow index

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Slow index
Дата
Msg-id 5564.1222348318@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Slow index  (Matthew Wakeling <matthew@flymine.org>)
Ответы Re: Slow index  (Matthew Wakeling <matthew@flymine.org>)
Список pgsql-performance
Matthew Wakeling <matthew@flymine.org> writes:
> Hi all. I'm having an interesting time performance-wise with a set of indexes.
> Any clues as to what is going on or tips to fix it would be appreciated.

Are the indexed columns all the same datatype?  (And which type is it?)

It might be helpful to REINDEX the "slow" index.  It's possible that
what you're seeing is the result of a chance imbalance in the btree,
which reindexing would fix.

            regards, tom lane

В списке pgsql-performance по дате отправления:

Предыдущее
От: Matthew Wakeling
Дата:
Сообщение: Slow index
Следующее
От: Matthew Wakeling
Дата:
Сообщение: Re: Slow index