Re: Redundant indexes?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jeffrey Tenny <jeffrey(dot)tenny(at)comcast(dot)net>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Redundant indexes?
Date: 2005-05-28 00:09:44
Message-ID: 1737.1117238984@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Jeffrey Tenny <jeffrey(dot)tenny(at)comcast(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Andrew McMillan 2005-05-28 05:08:10 Re: OID vs overall system performances on high load
Previous Message Bruce Momjian 2005-05-27 22:07:38 Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL