Re: default operator class: btree or hash

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: default operator class: btree or hash
Дата
Msg-id 20031201133323.GC14543@dcc.uchile.cl
обсуждение исходный текст
Ответ на default operator class: btree or hash  ("Dmitry G. Mastrukov" <dmitry@taurussoft.org>)
Список pgsql-hackers
On Mon, Dec 01, 2003 at 08:12:54AM +0300, Dmitry G. Mastrukov wrote:

> I'm preparing new release of uniqueidentifier datatype. In new relaease
> in addition to existing btree operator class I've implemented hash
> operator class. But what class should be default for this datatype?
> Uniqueidentifier is used for identification, so main operation with it
> is '=', on machines with /dev/urandom '<','>' operations have no meaning
> (parts for date and time are randomized). May be hash operator class
> should be default for uniqueidentifier?

btree is a better choice anyway because it allows for more concurrent
operation and it's far more tested.

-- 
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"No reniegues de lo que alguna vez creíste"


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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Where does catalog store CHAR length ?
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Foreign key data type mismatches