X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 1B70BD1B495; Fri, 12 Dec 2003 23:11:09 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 08644-05; Fri, 12 Dec 2003 19:10:40 -0400 (AST) Received: from bob.samurai.com (bob.samurai.com [205.207.28.75]) by svr1.postgresql.org (Postfix) with ESMTP id E4A7AD1CC78; Fri, 12 Dec 2003 19:10:36 -0400 (AST) Received: from tokyo.samurai.com (d226-89-59.home.cgocable.net [24.226.89.59]) by bob.samurai.com (Postfix) with ESMTP id 6BC5D205E; Fri, 12 Dec 2003 18:10:22 -0500 (EST) To: aspire420@hotpop.com Cc: pgsql-admin@postgresql.org, pgsql-performance@postgresql.org Subject: Re: [PERFORM] Tables Without OIDS and its effect From: Neil Conway In-Reply-To: <3FD9E916.8050005@sancharnet.in> (Sai Hertz And Control Systems's message of "Fri, 12 Dec 2003 21:43:10 +0530") References: <3FD9E916.8050005@sancharnet.in> Date: Fri, 12 Dec 2003 18:10:21 -0500 Message-ID: <87he05pr8i.fsf@mailbox.samurai.com> User-Agent: Gnus/5.1002 (Gnus v5.10.2) XEmacs/21.4 (Reasonable Discussion, linux) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/178 X-Sequence-Number: 11685 Sai Hertz And Control Systems writes: > I have created my tables without OIDS now my doubts are : > 1. Will this speed up the data insertion process Slightly. It means that each inserted row will be 4 bytes smaller (on disk), which in turn means you can fit more tuples on a page, and therefore you'll need fewer pages and less disk space. However, I'd be surprised if the performance improvement is very significant. > 2. Though I have not written any code in my any of the pgsql functions > which depend on OIDS > 1. Will without OIDS the functions behave internally differently > 2. Will my application break at any point No. BTW, we intend to phase out the use of OIDs for user tables in the long term. There have been a few threads on -hackers that discuss the plans for doing this. -Neil