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
- [GENERAL] Indexes on individual columns of composite primar... Dan Halbert
- Re: [GENERAL] Indexes on individual columns of composi... Tom Lane
- Re: [GENERAL] Indexes on individual columns of composi... Matthew Walden
- Re: [GENERAL] Indexes on individual columns of composi... Dann Corbit
- Re: [GENERAL] Indexes on individual columns of com... Dann Corbit
- Re: [GENERAL] Indexes on individual columns of... Matthew Walden