Indexes on individual columns of composite primary key

Поиск
Список
Период
Сортировка

I have a table with four columns. Three of those columns are defined as the composite primary key. Does it make sense to create indexes on any or all of those three columns individually for performance reasons? PG does let me create the indexes. But perhaps it's redundant, since there's an implicitly-created index for the composite primary key.

 

Thanks,

Dan

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

Предыдущее
От: Magnus Hagander
Дата:
Сообщение: Re: The first dedicated PostgreSQL forum
Следующее
От: Richard Broersma
Дата:
Сообщение: Re: The first dedicated PostgreSQL forum