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 62C40D1DFAC; Fri, 12 Dec 2003 16:16:05 +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 49681-02; Fri, 12 Dec 2003 12:15:36 -0400 (AST) Received: from ndl1mr1-a-fixed.sancharnet.in (ndl1mr1-a-fixed.sancharnet.in [61.0.0.45]) by svr1.postgresql.org (Postfix) with ESMTP id 5930ED1DFFD; Fri, 12 Dec 2003 12:11:26 -0400 (AST) Received: from conversion-daemon.ndl1mr1-a-fixed.sancharnet.in by ndl1mr1-a-fixed.sancharnet.in (iPlanet Messaging Server 5.2 HotFix 1.17 (built Jun 23 2003)) id <0HPS00701HUPJ5@ndl1mr1-a-fixed.sancharnet.in>; Fri, 12 Dec 2003 21:38:50 +0530 (IST) Received: from sancharnet.in ([61.0.95.114]) by ndl1mr1-a-fixed.sancharnet.in (iPlanet Messaging Server 5.2 HotFix 1.17 (built Jun 23 2003)) with ESMTPA id <0HPS00E3BI6JTR@ndl1mr1-a-fixed.sancharnet.in>; Fri, 12 Dec 2003 21:38:50 +0530 (IST) Date: Fri, 12 Dec 2003 21:43:10 +0530 From: Sai Hertz And Control Systems Subject: Tables Without OIDS and its effect To: pgsql-admin@postgresql.org Cc: pgsql-performance@postgresql.org Reply-To: aspire420@hotpop.com Message-id: <3FD9E916.8050005@sancharnet.in> Organization: Sai Hertz And Control Systems MIME-version: 1.0 Content-type: text/plain; format=flowed; charset=us-ascii Content-transfer-encoding: 7BIT X-Accept-Language: en-us, en User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.6b) Gecko/20031205 Thunderbird/0.4 X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests=BAYES_20, FROM_ENDS_IN_NUMS, RCVD_IN_OSIRUSOFT_COM, RCVD_IN_RFCI, USER_AGENT_MOZILLA_UA X-Spam-Level: X-Archive-Number: 200312/171 X-Sequence-Number: 11679 Dear all , I have created my tables without OIDS now my doubts are : 1. Will this speed up the data insertion process 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 3. I decided to work with out OIDS because 1. It has a limit of -2147483648 to +2147483647 2 Due to this limitation I would not like to drop recreate my database because it is a bit difficult/dirty process All links and suggestion pertaining to OIDS are most welcome my mail box is at your disposal and dont hassitate to drop a two line comment. ----------------------- My Sys Config: RH 9.0 PostgreSQL 7.3.4 GCC 3.2.2 PHP 4.3.4 ---------------------- Regards, V Kashyap