From: Navkirat Singh <navkirats@gmail.com>
To: pgsql-performance@postgresql.org
Subject: UUID performance as primary key
Date: Sat, 16 Oct 2010 07:28:04 +0530
Message-ID: <63CD89CB-22F6-441C-ACBF-F76906B7E468@gmail.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: navkirats@gmail.com
Subject: Re: UUID performance as primary key
In-Reply-To: <63CD89CB-22F6-441C-ACBF-F76906B7E468@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox