Indexes on individual columns of composite primary key

From: "Dan Halbert" <halbert(at)halwitz(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Indexes on individual columns of composite primary key
Date: 2010-11-15 20:01:03
Message-ID: 1289851263.04424526@beta.apps.rackspace.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Greg Smith 2010-11-15 20:02:20 Re: The first dedicated PostgreSQL forum
Previous Message hubert depesz lubaczewski 2010-11-15 20:00:02 Re: Backends "hanging" with strace showing selects?