Re: [PERFORM] UUID performance as primary key

2010-10-16 Thread Merlin Moncure
On Fri, Oct 15, 2010 at 10:59 PM, Craig Ringer wrote: > On 16/10/2010 9:58 AM, Navkirat Singh wrote: >> >> 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 sm

Re: [PERFORM] UUID performance as primary key

2010-10-16 Thread Craig James
On 10/15/10 6:58 PM, Navkirat Singh wrote: 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 n

Re: [PERFORM] UUID performance as primary key

2010-10-15 Thread Andy
r wrote: From: Craig Ringer Subject: Re: [PERFORM] UUID performance as primary key To: "Navkirat Singh" Cc: pgsql-performance@postgresql.org Date: Friday, October 15, 2010, 10:59 PM On 16/10/2010 9:58 AM, Navkirat Singh wrote: > Hi Guys, > > I am interested in finding ou

Re: [PERFORM] UUID performance as primary key

2010-10-15 Thread Craig Ringer
On 16/10/2010 9:58 AM, Navkirat Singh wrote: 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.

[PERFORM] UUID performance as primary key

2010-10-15 Thread Navkirat Singh
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 da