Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Difference between PRIMARY KEY index and UNIQUE-NOT NULL index
Date
Msg-id 1905.1185124808@sss.pgh.pa.us
Whole thread Raw
In response to Re: Difference between PRIMARY KEY index and UNIQUE-NOT NULL index  (Vincenzo Romano <vincenzo.romano@gmail.com>)
Responses Re: Difference between PRIMARY KEY index and UNIQUE-NOT NULL index  (Vincenzo Romano <vincenzo.romano@gmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Foreign key constraint question
Next
From: "Sibte Abbas"
Date:
Subject: Re: Debugging postgresql source on gdb