Re: TODO item: GUID - Mailing list pgsql-hackers

From Tom Lane
Subject Re: TODO item: GUID
Date
Msg-id 23027.1157849934@sss.pgh.pa.us
Whole thread Raw
In response to Re: TODO item: GUID  (mark@mark.mielke.cc)
List pgsql-hackers
> On Sat, Sep 09, 2006 at 07:47:19PM +0200, Aleksandar Dezelin wrote:
>> Using time based GUIDs in database tables is not a good choice for
>> performance reasons because they can not be indexed properly - every newly
>> created time-based GUID is guaranteed to be larger than all previously
>> created, so RDBMS engine must re balance b-tree every time a new GUID item
>> is added to data table.

Only if you have a particularly bad b-tree implementation.  Do you also
not believe in indexing timestamp or serial columns?
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Jeremy Kronuz"
Date:
Subject: ISBN/ISSN/ISMN/EAN13 module
Next
From: Tom Lane
Date:
Subject: Re: ISBN/ISSN/ISMN/EAN13 module