Re: Difference between PRIMARY KEY index and UNIQUE-NOT NULL index

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Difference between PRIMARY KEY index and UNIQUE-NOT NULL index
Дата
Msg-id 2454.1185127743@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Difference between PRIMARY KEY index and UNIQUE-NOT NULL index  (Vincenzo Romano <vincenzo.romano@gmail.com>)
Список pgsql-general
Дерево обсуждения 
Vincenzo Romano <vincenzo.romano@gmail.com> writes:
> On Sunday 22 July 2007 19:20:08 Tom Lane wrote:
>> With what index, pray tell?

> 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.

You haven't said where you think this index is coming from.

            regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: Vincenzo Romano
Дата:
Сообщение: Re: Difference between PRIMARY KEY index and UNIQUE-NOT NULL index
Следующее
От: Shreya Bhargava
Дата:
Сообщение: Re: Debugging postgresql source on gdb