Thread: default operator class: btree or hash

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

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"