Indexes on individual columns of composite primary key

Поиск
Список
Период
Сортировка
От Dan Halbert
Тема Indexes on individual columns of composite primary key
Дата
Msg-id 1289851263.04424526@beta.apps.rackspace.com
обсуждение исходный текст
Ответы Re: Indexes on individual columns of composite primary key  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Indexes on individual columns of composite primary key  (Matthew Walden <matthew.walden.list@gmail.com>)
Re: Indexes on individual columns of composite primary key  (Dann Corbit <DCorbit@connx.com>)
Список pgsql-general

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