Postgres Pro
Downloads
Home   >   mailing lists

UUID, performance of primary keys - Mailing list pgsql-novice

From Andreas Junius
Subject UUID, performance of primary keys
Date
Msg-id 4A39EBBB.5030205@junius.info
Whole thread Raw
Responses Re: UUID, performance of primary keys
List pgsql-novice
Tree view 
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

pgsql-novice by date:

Previous
From: MITCHELL CIFUENTES
Date:
Subject: Re: problem with sequence number using a trigger
Next
From: Sean Davis
Date:
Subject: Re: UUID, performance of primary keys