Postgres Pro
Downloads
Home   >   mailing lists

Re: Redundant indexes? - Mailing list pgsql-performance

From Tom Lane
Subject Re: Redundant indexes?
Date
Msg-id 1737.1117238984@sss.pgh.pa.us
Whole thread Raw
In response to Redundant indexes?  (Jeffrey Tenny <jeffrey.tenny@comcast.net>)
List pgsql-performance
Tree view 
Jeffrey Tenny <jeffrey.tenny@comcast.net> writes:
> Would I be correct in assuming that the following two indexes are
> completely redundant except for the fact that one complains about
> uniqueness constraint violations and the other does not?

Yup ...

            regards, tom lane

pgsql-performance by date:

Previous
From: Jeffrey Tenny
Date:
Subject: Redundant indexes?
Next
From: Andrew McMillan
Date:
Subject: Re: OID vs overall system performances on high load