Re: UUID - Data type inefficient - Mailing list pgsql-hackers

From Tom Lane
Subject Re: UUID - Data type inefficient
Date
Msg-id 4298.1215705643@sss.pgh.pa.us
Whole thread Raw
In response to Re: UUID - Data type inefficient  (Mark Mielke <mark@mark.mielke.cc>)
Responses Re: UUID - Data type inefficient  (Gregory Stark <stark@enterprisedb.com>)
List pgsql-hackers
Mark Mielke <mark@mark.mielke.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


pgsql-hackers by date:

Previous
From: Mark Mielke
Date:
Subject: Re: UUID - Data type inefficient
Next
From: Mark Mielke
Date:
Subject: Re: UUID - Data type inefficient