UUID, performance of primary keys

From: "Andreas Junius" <andreas(at)junius(dot)info>
To: pgsql-novice(at)postgresql(dot)org
Subject: UUID, performance of primary keys
Date: 2009-06-18 07:24:43
Message-ID: 4A39EBBB.5030205@junius.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi Postgres professionals,

I'd like to use UUID for object id's (java.util.UUID). Such an object
consists of two long values. I could now use two columns (int8) in a
table for the primary key or one using the string representation. But I
don't know which option is the more performant one or if there exist
another more suitable solution. Does anybody know more about this issue?

Andreas

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Sean Davis 2009-06-18 12:00:08 Re: UUID, performance of primary keys
Previous Message MITCHELL CIFUENTES 2009-06-18 02:46:24 Re: problem with sequence number using a trigger