UUID performance as primary key - Mailing list pgsql-performance

From Navkirat Singh
Subject UUID performance as primary key
Date
Msg-id 63CD89CB-22F6-441C-ACBF-F76906B7E468@gmail.com
Whole thread Raw
Responses Re: UUID performance as primary key  (Craig Ringer <craig@postnewspapers.com.au>)
Re: UUID performance as primary key  (Craig James <craig_james@emolecules.com>)
List 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
wouldbe 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
figurethis out, as it is critical for my project. 

Thanks in advance,

Nav

pgsql-performance by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: Stored procedure declared as VOLATILE => no good optimization is done
Next
From: Tom Lane
Date:
Subject: Re: Stored procedure declared as VOLATILE => no good optimization is done