Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id E17982E2F9C for ; Thu, 6 Mar 2008 03:22:55 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 20223-02 for ; Thu, 6 Mar 2008 03:22:53 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from flame.co.za (websvn.rascal.co.za [160.124.170.1]) by postgresql.org (Postfix) with ESMTP id DFECB2E2F4F for ; Thu, 6 Mar 2008 03:22:52 -0400 (AST) Received: from [192.168.0.138] (unknown [196.209.62.7]) (using TLSv1 with cipher RC4-MD5 (128/128 bits)) (No client certificate requested) by flame.co.za (Postfix) with ESMTP id 0F20F802A0 for ; Thu, 6 Mar 2008 09:22:08 +0200 (SAST) Subject: Re: oid...any optimizations From: Theo Kramer Reply-To: theo@flame.co.za To: pgsql-performance@postgresql.org In-Reply-To: References: Content-Type: text/plain Organization: Flame Computing Enterprises cc Date: Thu, 06 Mar 2008 09:21:36 +0200 Message-Id: <1204788096.2332.18.camel@localhost6.localdomain6> Mime-Version: 1.0 X-Mailer: Evolution 2.10.3 (2.10.3-4.fc7) Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/108 X-Sequence-Number: 29062 On Thu, 2008-03-06 at 12:32 +0530, sathiya psql wrote: > i had a table with 50 lakh record... > > it has a column called oid ( obviously all the tables will have > this ), but while doing any operation it is getting slow because of > the number of records... > > if i remove the oid column will i get any benefit, what are all the > other default columns created without our knowledge.. Probably not Also - do not remove oid if your sql operations require it. A 'create index x_oid_idx on table x (oid)' might help. Also see EXPLAIN in the manual. -- Regards Theo