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
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 |