| From: | Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl> |
|---|---|
| To: | "Dmitry G(dot) Mastrukov" <dmitry(at)taurussoft(dot)org> |
| Cc: | PostgreSQL-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: default operator class: btree or hash |
| Date: | 2003-12-01 13:33:23 |
| Message-ID: | 20031201133323.GC14543@dcc.uchile.cl |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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"
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2003-12-01 14:12:35 | Re: ISO 8601 "Time Intervals" of the "format with time-unit |
| Previous Message | Alvaro Herrera | 2003-12-01 13:32:17 | Re: Where does catalog store CHAR length ? |