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

From Andrew Dunstan
Subject Re: UUID - Data type inefficient
Date
Msg-id 4876290D.5090104@dunslane.net
Whole thread Raw
In response to UUID - Data type inefficient  (Kless <jonas.esp@googlemail.com>)
List pgsql-hackers

Kless wrote:
> 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
> ------------
>   


No it is not. It is stored as 16 binary bytes. As text it won't fit into 
16 bytes.


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


What on earth makes you assume that MySQL performance characteristics 
apply to PostgreSQL? If you want to show that our implementation is 
inefficient, you need to produce PostgreSQL performance tests to 
demonstrate it.

cheers

andrew



pgsql-hackers by date:

Previous
From: Aidan Van Dyk
Date:
Subject: Re: WITH RECURSIVE updated to CVS TIP
Next
From: Tom Lane
Date:
Subject: Re: initdb in current cvs head broken?