Re: UUID - Data type inefficient

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Mark Mielke <mark(at)mark(dot)mielke(dot)cc>
Cc: Kless <jonas(dot)esp(at)googlemail(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: UUID - Data type inefficient
Date: 2008-07-10 16:00:43
Message-ID: 4298.1215705643@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Mark Mielke <mark(at)mark(dot)mielke(dot)cc> writes:
> Kless wrote:
>> [1] http://www.mysqlperformanceblog.com/2007/03/13/to-uuid-or-not-to-uuid/

> That's a general page about UUID vs serial integers.

AFAICT the author of that page thinks that UUIDs are stored in ASCII
form (32 hex digits), which would indeed be inefficient. I have no
idea whether he knows what he's talking about with respect to mysql,
but it's certainly 100% irrelevant to the Postgres datatype.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Mark Mielke 2008-07-10 16:01:03 Re: UUID - Data type inefficient
Previous Message Mark Mielke 2008-07-10 15:52:57 Re: UUID - Data type inefficient