Indexes & Primary Keys (based on the same columns) - Mailing list pgsql-general

From Ow Mun Heng
Subject Indexes & Primary Keys (based on the same columns)
Date
Msg-id 1193024654.1104.26.camel@neuromancer.home.net
Whole thread Raw
Responses Re: Indexes & Primary Keys (based on the same columns)  ("Joshua D. Drake" <jd@commandprompt.com>)
Re: Indexes & Primary Keys (based on the same columns)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
I'm wondering if what I'm doing is redundant.

I have a primary key on columns (A,B,C,D)
and I've also defined an index based on the same columns (A,B,C,D)

and sometimes in the query explain, I see the pkey being used for the
scan instead of the index.

So.. That made me think perhaps the additional index on the _same_
parameter is redundant.

Appreciate comments.



pgsql-general by date:

Previous
From: Ow Mun Heng
Date:
Subject: Re: command to view the tables
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Indexes & Primary Keys (based on the same columns)