[GENERAL] varchar as primary key

[Matthew Hixson]

I'm investigating the usage of a UUID primary key generator using  
Hibernate and Postgres.  The reason for using a UUID is that we will  
have an application hosted at different sites in different  
databases.  We will need to aggregate the data back into a single  
database from time to time and we want to avoid PK collisions.
  Is there a significant performance difference between using int  
primary keys and string primary keys in Postgres?
  Thanks,
   -M@

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
              http://www.postgresql.org/docs/faq