Postgres Pro
Downloads
Home   >   mailing lists

UNIQUE performance? - Mailing list pgsql-general

From Chris Bitmead
Subject UNIQUE performance?
Date
Msg-id 37250C7C.4DE0952F@bigfoot.com
Whole thread Raw
In response to 9k limit?  ("Justin Long" <justinlong@strategicnetwork.org>)
List pgsql-general
Tree view 
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 ?

pgsql-general by date:

Previous
From: Chris Bitmead
Date:
Subject: INDEXes and UNIQUES and PRIMARY KEYS
Next
From: Chris Bitmead
Date:
Subject: INDEXes and "*" notation ?