X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 7FD2A9F9AD3 for ; Mon, 26 Jun 2006 11:36:08 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 78763-05 for ; Mon, 26 Jun 2006 11:36:01 -0300 (ADT) X-Greylist: delayed 00:26:14.452889 by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id D37C59FA42B for ; Mon, 26 Jun 2006 11:36:01 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from 115.N1.EF.nwx-server.de (115.N1.EF.nwx-server.de [217.114.219.115]) by svr4.postgresql.org (Postfix) with ESMTP id D11CD5AF036 for ; Mon, 26 Jun 2006 14:09:45 +0000 (GMT) Received: from spheron.com (Eaa03.ex.pppool.de [194.97.170.3]) by 115.N1.EF.nwx-server.de (Postfix) with ESMTP id C88D927036B for ; Mon, 26 Jun 2006 16:09:36 +0200 (CEST) DomainKey-Signature: a=rsa-sha1; s=MDaemon; d=spheron.com; c=simple; q=dns; h=message-id:from; b=WbpiJj4c+Wf1c3ehtIioS6MfpeO+D4474jJ1+vp1Xw9rxaEPfvFHrYeJOXEv n0uzJhicpXEfva16yxxOqwiaR5pvEBypig6azBLWfndugWCUzI9VONGGY Z57UR22Owc/ZnUrHXdjXEXOBlsdJCWg+PX7NJcbcx/LovmdiH2p3eA=; Received: from [127.0.0.1] by spheron.com (MDaemon PRO v9.0.4) with ESMTP id md50000484666.msg for ; Mon, 26 Jun 2006 16:08:12 +0200 Message-ID: <449FE9AD.7010400@Spheron.com> Date: Mon, 26 Jun 2006 16:05:33 +0200 From: Dennis Wagner Organization: SpheronVR AG User-Agent: Thunderbird 1.5.0.4 (Windows/20060516) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Using GUIDs Content-Type: text/plain; charset=ISO-8859-15; format=flowed Content-Transfer-Encoding: 7bit X-Authenticated-Sender: wagner@spheron.com X-Spam-Processed: spheron.com, Mon, 26 Jun 2006 16:08:12 +0200 (not processed: message from valid local sender) X-MDRemoteIP: 192.168.0.60 X-Return-Path: wagner@Spheron.com X-MDaemon-Deliver-To: pgsql-admin@postgresql.org X-MDAV-Processed: spheron.com, Mon, 26 Jun 2006 16:08:13 +0200 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/227 X-Sequence-Number: 22189 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