Indexes on individual columns of composite primary key - Mailing 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