Re: TODO item: GUID

From: "Aleksandar Dezelin" <dezelin(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: TODO item: GUID
Date: 2006-09-09 17:47:19
Message-ID: ea977f560609091047p4d56cb71gdb25afc935939126@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello,

you just have to make random 128 bits and set version bits. And that's all.

This is the way this data type is implemented in Mono
(http://svn.myrealbox.com/source/trunk/mcs/class/corlib/System/Guid.cs).

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.

Sorry, for sending this message three times - problem with Gmail.

Cheers,
Aleksandar Dezelin

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message David Fetter 2006-09-09 17:48:30 Re: log_duration is redundant, no?
Previous Message Stephan Szabo 2006-09-09 17:26:08 Re: Proposal for GUID datatype