On Sunday 22 July 2007 19:20:08 Tom Lane wrote: > Vincenzo Romano <vincenzo.romano@xxxxxxxxx> 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]
