RE: [GENERAL] UNIQUE performance?

Поиск
Список
Период
Сортировка
От Jackson, DeJuan
Тема RE: [GENERAL] UNIQUE performance?
Дата
Msg-id D05EF808F2DFD211AE4A00105AA1B5D20DCBA7@cpsmail
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: "Jackson, DeJuan"
Дата:
Сообщение: RE: [GENERAL] INDEXes and UNIQUES and PRIMARY KEYS
Следующее
От: Anand Surelia
Дата:
Сообщение: DBI driver for Postgres?