X-Original-To: pgsql-performance@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id B80934758F1 for ; Wed, 26 Feb 2003 11:00:39 -0500 (EST) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with SMTP id 80531-04 for ; Wed, 26 Feb 2003 11:00:27 -0500 (EST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id BEF24475BF9 for ; Wed, 26 Feb 2003 10:56:08 -0500 (EST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.6/8.12.6) with ESMTP id h1QFu45u029872; Wed, 26 Feb 2003 10:56:04 -0500 (EST) To: daniel alvarez Cc: Richard Huxton , pgsql-performance@postgresql.org Subject: Re: OIDs as keys In-reply-to: <24135.1046271575@www36.gmx.net> References: <200302261358.53730.dev@archonet.com> <24135.1046271575@www36.gmx.net> Comments: In-reply-to daniel alvarez message dated "Wed, 26 Feb 2003 15:59:35 +0100" Date: Wed, 26 Feb 2003 10:56:04 -0500 Message-ID: <29871.1046274964@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new X-Archive-Number: 200302/212 X-Sequence-Number: 1268 daniel alvarez writes: > Why should user-defined tables have OIDs by default? At this point it's just for historical reasons. There actually is a proposal on the table to flip the default to WITHOUT OIDS, but so far it's not been accepted because of worries about compatibility. See the pghackers archives a few weeks back. regards, tom lane