Re: TODO item: GUID

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Aleksandar Dezelin <dezelin(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: TODO item: GUID
Date: 2006-09-10 00:58:54
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Chris Mair 2006-09-10 08:36:10 Re: Foreign keys
Previous Message Michael Glaesemann 2006-09-10 00:46:49 Re: @ versus ~, redux