Indexes on individual columns of composite primary key - Mailing list pgsql-general

From Dan Halbert
Subject Indexes on individual columns of composite primary key
Date
Msg-id 1289851263.04424526@beta.apps.rackspace.com
Whole thread Raw
Responses 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>)
List 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 by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: The first dedicated PostgreSQL forum
Next
From: Richard Broersma
Date:
Subject: Re: The first dedicated PostgreSQL forum