RE: [GENERAL] UNIQUE performance? - Mailing list pgsql-general

From Jackson, DeJuan
Subject RE: [GENERAL] UNIQUE performance?
Date
Msg-id D05EF808F2DFD211AE4A00105AA1B5D20DCBA7@cpsmail
Whole thread Raw
List pgsql-general
> If I want to have an index on oid, which will obviously be unique
> anyway, is it more efficient to have or not to have the UNIQUE option on
> CREATE INDEX ?
Good question my thought would be not to have the Unique; then the Indexing
code doesn't have to check for duplicates when inserting new values.
    -DEJ

pgsql-general by date:

Previous
From: "Jackson, DeJuan"
Date:
Subject: RE: [GENERAL] INDEXes and UNIQUES and PRIMARY KEYS
Next
From: Anand Surelia
Date:
Subject: DBI driver for Postgres?