UUID vs int keys....

From: Nathan Wilhelmi <wilhelmi(at)ucar(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: UUID vs int keys....
Date: 2008-03-03 20:15:07
Message-ID: 47CC5C4B.2030608@ucar.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello - Curious if anyone has any experience with the new UUID type in
8.3? We are currently using sequences for all of our keys and ids.
However using a UUID instead of a sequence would make some parts of the
application easier. However we have a few concerns about performance
issues surrounding the new type. Are they any significant impacts with
respect to indexing 'random' values over a serial value? The UUID would
obviously take up a bit more storage than the int based option. Are
there any particular join gotchas etc with using a UUID? Any other
gotchas to watch out for?

Thanks!

-Nate

Browse pgsql-general by date

  From Date Subject
Next Message Юрий Шустов 2008-03-03 20:23:45 ОСНОВЫ УПРАВЛЕНИЯ ПРОЕКТАМИ: ОТ ИДЕИ ДО РЕАЛИЗАЦИИ. ГОТОВЫЕ РЕШЕНИЯ
Previous Message Josh Trutwin 2008-03-03 20:05:38 Re: PostgreSQL Array Use