Fw: UUID vs Serial or BigSerial

["Mike Gould" <mgould@xxxxxxxxxxxx>]

All,

 

From a performance standpoint what is the downside to using a UUID column?  Our current database with 25 locations after 5 years is only about 2.5 gig.  We do about 200,000 orders per year so we are not getting hit with a huge amount

of data.  Much of our data is static or once it has been processed it is static from that point forward.  The only reason that I was thinking about using a UUID data type is that this is a commerical product and we are also looking to move into

the ASP space.  It is possible that we might have 2 companies merge and I thought that using the UUID would cause less hassles if we had to merge 2 databases.  That being said the changes of that happening are pretty slim.  I've got one

DBA telling me that I should be using a UUID datatype for all of our tables.

Best Regards,

Michael Gould, Manager Information Technology
All Coast Intermodal Services, Inc.
First Coast Intermodal Services, Inc.
First Coast Logistics Services, LLC.
904-226-0978
904-592-5250 fax