Re: Difference between PRIMARY KEY index and UNIQUE-NOT NULL index - Mailing list pgsql-general

On Sunday 22 July 2007 19:20:08 Tom Lane wrote:
> Vincenzo Romano <vincenzo.romano@gmail.com> writes:
> > In the original setup, the "UNIQUE" constraint had been dropped
> > *before* doing the tests. So the "slow" case is without the
> > UNIQUE constraint but with an index. The NOT NULL was instead
> > there.
>
> With what index, pray tell?
>
>             regards, tom lane

Sorry for the incomplete sentence.
Read it as:

In the original setup, the "UNIQUE" constraint had been dropped
*before* doing the tests. So the "slow" case is without the
UNIQUE constraint but with an index on NOT NULL fields.

The "fast" case was with the primary key on the very same fields
in the very same order.

--
Vincenzo Romano
--
Maybe Computer will never become as intelligent as Humans.
For sure they won't ever become so stupid. [VR-1988]