X-Original-To: pgsql-performance@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 73D99474E42 for ; Wed, 26 Feb 2003 11:14:26 -0500 (EST) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with SMTP id 82222-10 for ; Wed, 26 Feb 2003 11:14:15 -0500 (EST) Received: from anchor-post-32.mail.demon.net (anchor-post-32.mail.demon.net [194.217.242.90]) by postgresql.org (Postfix) with ESMTP id 427A9475B33 for ; Wed, 26 Feb 2003 11:10:11 -0500 (EST) Received: from mwynhau.demon.co.uk ([193.237.186.96] helo=mainbox.archonet.com) by anchor-post-32.mail.demon.net with esmtp (Exim 3.35 #1) id 18o48N-000HfL-0W; Wed, 26 Feb 2003 16:10:15 +0000 Received: from localhost (localhost.localdomain [127.0.0.1]) by mainbox.archonet.com (Postfix) with ESMTP id 8E5D6171C9; Wed, 26 Feb 2003 16:10:14 +0000 (GMT) Received: from client.archonet.com (client.archonet.com [192.168.1.16]) by mainbox.archonet.com (Postfix) with ESMTP id E3D16171C8; Wed, 26 Feb 2003 16:10:13 +0000 (GMT) Content-Type: text/plain; charset="iso-8859-1" From: Richard Huxton Organization: Archonet Ltd To: daniel alvarez Subject: Re: OIDs as keys Date: Wed, 26 Feb 2003 16:10:13 +0000 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 Content-Transfer-Encoding: quoted-printable Message-Id: <200302261610.13115.dev@archonet.com> X-Virus-Scanned: by AMaViS snapshot-20020531 X-Virus-Scanned: by amavisd-new X-Archive-Number: 200302/214 X-Sequence-Number: 1270 On Wednesday 26 Feb 2003 2:59 pm, daniel alvarez wrote: > > Why should user-defined tables have OIDs by default? Other DBMS use ROWIDs > as the physical storage location used for pointers in index leafs, but th= is > is equivalent > to Postgres TIDs. To the user an OID column is not different than any oth= er > column > he can define himself. I'd find it more natural if the column wasn't there > at all. I believe the plan is to phase them out, but some people are using them, so= =20 the default is still to create them. Imagine if you were using OIDs as keys= =20 and after a dump/restore they were all gone... --=20 Richard Huxton