Re: Indexing question

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Indexing question
Дата
Msg-id 15992.1062165614@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Indexing question  ("Alexander Priem" <ap@cict.nl>)
Список pgsql-performance
"Alexander Priem" <ap@cict.nl> writes:
> Does anyone know whether it is bad practise to have two indexes on the
> primary key of a table? (one 'primary key' index and one partial index)

It's a little unusual, but if you get enough performance boost from it
to justify the maintenance cost of the extra index, then I can't see
anything wrong with it.

The "if" is worth checking though.  I missed the start of this thread,
but what percentage of your rows do you expect to have null deleteddate?
Unless it's a pretty small percentage, I'm unconvinced that the extra
indexes will be worth their cost.

            regards, tom lane

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

Предыдущее
От: Oliver Siegmar
Дата:
Сообщение: PL/pgSQL functions - text / varchar - havy performance issue?!
Следующее
От: Andrew Sullivan
Дата:
Сообщение: Re: Hardware recommendations to scale to silly load