From: Aaron Bono <postgresql@aranya.com>
To: Dennis Wagner <wagner@spheron.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Using GUIDs
Date: Mon, 26 Jun 2006 19:15:32 -0500
Message-ID: <bf05e51c0606261715o42b5d352v53c0f8e37e81b002@mail.gmail.com> (raw)
In-Reply-To: <449FE9AD.7010400@Spheron.com>
References: <449FE9AD.7010400@Spheron.com>
By its definition, GUID ( http://en.wikipedia.org/wiki/GUID ) is not
guaranteed to be unique. As a result, it could cause problems in tables
that have a large number of rows - actually this could result in hard to
reproduce, seemingly random errors in your systems that use the database.
How does a GUID help you over a BIGSERIAL?
Unless you are generating the PK in multiple databases, a BIGSERIAL should
act as a UUID.
Maybe if you provide a little more detail on why you want to use GUID or
UUID fields we can help you come up with more options.
Thanks,
Aaron
On 6/26/06, Dennis Wagner <wagner@spheron.com> wrote:
>
> Hi list!
>
> I'm currently thinking about using GUIDs as primary keys. To be more
> precise: On *some* of the tables in my structure I *will* need GUIDs (or
> UUIDs or whatever format may proove usefull). Now, this implies that
> using a bigserial-field for readability and the uids is redundand, so
> I'm thinking of dropping my current primary-key-columns in favor of an
> uuid-column.
> In the postgres-docs I can't find any built-in data-types directly
> supporting guids. I found the project pguuid on gborg but it somehow
> lacks documentation and doesn't seem very promising (since it doesn't
> seem to be touched since three years ago...).
> I have found some older discussion on the archives but in the end noone
> ever came up with THE solution nor did anyone talk about the
> performance-impact using a guid-row as primary key would have over
> using, let's say bigint.
> Has anyone made some test in this field and can share some experiences?
> Would this question be better placed in the hackers list?
>
> Best regards
>
>
>
> Dennis
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: postgresql@aranya.com, wagner@spheron.com
Subject: Re: Using GUIDs
In-Reply-To: <bf05e51c0606261715o42b5d352v53c0f8e37e81b002@mail.gmail.com>
References: <449FE9AD.7010400@Spheron.com> <bf05e51c0606261715o42b5d352v53c0f8e37e81b002@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox