UUID performance as primary key

From: Navkirat Singh <navkirats(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: UUID performance as primary key
Date: 2010-10-16 01:58:04
Message-ID: 63CD89CB-22F6-441C-ACBF-F76906B7E468@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi Guys,

I am interested in finding out the pros/cons of using UUID as a primary key field. My requirement states that UUID would be perfect in my case as I will be having many small databases which will link up to a global database using the UUID. Hence, the need for a unique key across all databases. It would be extremely helpful if someone could help me figure this out, as it is critical for my project.

Thanks in advance,

Nav

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2010-10-16 02:31:34 Re: Stored procedure declared as VOLATILE => no good optimization is done
Previous Message Tatsuo Ishii 2010-10-16 01:47:38 Re: Stored procedure declared as VOLATILE => no good optimization is done