Re: Indexes on individual columns of composite primary key

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Dan Halbert" <halbert(at)halwitz(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Indexes on individual columns of composite primary key
Date: 2010-11-15 20:16:22
Message-ID: 5975.1289852182@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Dan Halbert" <halbert(at)halwitz(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Matthew Walden 2010-11-15 20:18:49 Re: Indexes on individual columns of composite primary key
Previous Message Joshua D. Drake 2010-11-15 20:13:34 Re: The first dedicated PostgreSQL forum