| From: | Vincenzo Romano <vincenzo(dot)romano(at)gmail(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | "Josh Tolley" <eggyknap(at)gmail(dot)com>, "Michael Glaesemann" <grzm(at)seespotcode(dot)net>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Difference between PRIMARY KEY index and UNIQUE-NOT NULL index |
| Date: | 2007-07-22 17:31:08 |
| Message-ID: | 200707221931.09970.vincenzo.romano@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Sunday 22 July 2007 19:20:08 Tom Lane wrote:
> Vincenzo Romano <vincenzo(dot)romano(at)gmail(dot)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]
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sibte Abbas | 2007-07-22 17:33:00 | Re: Debugging postgresql source on gdb |
| Previous Message | Sibte Abbas | 2007-07-22 17:30:11 | Re: Debugging postgresql source on gdb |