X-Original-To: pgsql-performance@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 4F9B0475B99 for ; Wed, 26 Feb 2003 12:24:09 -0500 (EST) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with SMTP id 94107-06 for ; Wed, 26 Feb 2003 12:23:55 -0500 (EST) Received: from davinci.ethosmedia.com (unknown [209.10.40.251]) by postgresql.org (Postfix) with ESMTP id 84021475A8D for ; Wed, 26 Feb 2003 12:18:27 -0500 (EST) Received: from [63.195.55.98] (HELO spooky) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.0.2) with ESMTP id 2870538; Wed, 26 Feb 2003 09:18:15 -0800 Content-Type: text/plain; charset="iso-8859-1" From: Josh Berkus Organization: Aglio Database Solutions To: daniel alvarez , Richard Huxton Subject: Re: OIDs as keys Date: Wed, 26 Feb 2003 09:17:24 -0800 User-Agent: KMail/1.4.3 Cc: pgsql-performance@postgresql.org References: <200302261358.53730.dev@archonet.com> <24135.1046271575@www36.gmx.net> In-Reply-To: <24135.1046271575@www36.gmx.net> MIME-Version: 1.0 Message-Id: <200302260917.24500.josh@agliodbs.com> Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: by amavisd-new X-Archive-Number: 200302/215 X-Sequence-Number: 1271 Daniel, > There can also be some problems when using replication, because one needs > to make > sure that OIDs are the same on all machines in the cluster. See the "uniqueidentifier" contrib package if you need a universally unique= id=20 for replication. > I'd find it more natural if the column wasn't there > at all. Probably by Postgres 8.0, it won't be. --=20 Josh Berkus Aglio Database Solutions San Francisco