default operator class: btree or hash

Started by Dmitry G. Mastrukovabout 22 years ago2 messages
#1Dmitry G. Mastrukov
dmitry@taurussoft.org

Hi, all!

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?

Regards,
Dmitry

#2Alvaro Herrera
alvherre@dcc.uchile.cl
In reply to: Dmitry G. Mastrukov (#1)
Re: default operator class: btree or hash

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"