UUID - Data type inefficient - Mailing list pgsql-hackers

From Kless
Subject UUID - Data type inefficient
Date
Msg-id 9304edd3-33bb-466b-86a7-71f62b6d9750@d45g2000hsc.googlegroups.com
Whole thread Raw
Responses Re: UUID - Data type inefficient  (Andrew Dunstan <andrew@dunslane.net>)
Re: UUID - Data type inefficient  (Mark Mielke <mark@mark.mielke.cc>)
List pgsql-hackers
The new data type, UUID, is stored as a string -char(16)-:

------------
struct pg_uuid_t
{       unsigned char data[UUID_LEN];
};
#define UUID_LEN 16
------------

but this it's very inefficient as you can read here [1].

The ideal would be use bit(128), but today isn't possible. One
possible solution would be create a structure with 2 fields, each one
with bit(64).


[1] http://www.mysqlperformanceblog.com/2007/03/13/to-uuid-or-not-to-uuid/


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: CommitFest rules
Next
From: Aidan Van Dyk
Date:
Subject: Re: WITH RECURSIVE updated to CVS TIP