Re: UUID - Data type inefficient

From: Mark Mielke <mark(at)mark(dot)mielke(dot)cc>
To: Kless <jonas(dot)esp(at)googlemail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: UUID - Data type inefficient
Date: 2008-07-10 16:05:19
Message-ID: 4876333F.7080005@mark.mielke.cc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Mark Mielke wrote:
> I didn't notice that he put 16. Now I'm looking at uuid.c in
> PostgreSQL 8.3.3 and I see that it does use 16, and the struct
> pg_uuid_t is length 16. I find myself confused now - why does
> PostgreSQL define UUID_LEN as 16?
>
> I will investigate if I have time tonight. There MUST be some mistake
> or misunderstanding. 128-bit numbers should be stored as 8 bytes, not 16.

Grrrr.... Kless you've confused me. 32-bit numbers = 4 bytes, 64-bit
numbers = 8 bytes, 128-bit numbers = 16 bytes.

You are out to lunch and you dragged me with you. Did we have beer at
least? :-)

Cheers,
mark

--
Mark Mielke <mark(at)mielke(dot)cc>

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Aidan Van Dyk 2008-07-10 16:09:42 Re: WITH RECURSIVE updated to CVS TIP
Previous Message Mark Mielke 2008-07-10 16:01:03 Re: UUID - Data type inefficient