Re: default operator class: btree or hash - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: default operator class: btree or hash
Date
Msg-id 20031201133323.GC14543@dcc.uchile.cl
Whole thread Raw
In response to default operator class: btree or hash  ("Dmitry G. Mastrukov" <dmitry@taurussoft.org>)
List 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 by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Where does catalog store CHAR length ?
Next
From: Bruce Momjian
Date:
Subject: Re: Foreign key data type mismatches