Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Indexes on individual columns of composite primary key
Date
Msg-id 5975.1289852182@sss.pgh.pa.us
Whole thread Raw
In response to Indexes on individual columns of composite primary key  ("Dan Halbert" <halbert@halwitz.org>)
List pgsql-general
Tree view 
"Dan Halbert" <halbert@halwitz.org> writes:
> 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?

Please see
http://www.postgresql.org/docs/9.0/static/indexes.html
particularly sections 11.3 and 11.5.

            regards, tom lane

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: The first dedicated PostgreSQL forum
Next
From: Matthew Walden
Date:
Subject: Re: Indexes on individual columns of composite primary key