X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id C19C053FBA for ; Fri, 15 Apr 2005 11:25:00 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 28235-04 for ; Fri, 15 Apr 2005 14:24:52 +0000 (GMT) Received: from sccrmhc13.comcast.net (sccrmhc13.comcast.net [204.127.202.64]) by svr1.postgresql.org (Postfix) with ESMTP id D01F153FB2 for ; Fri, 15 Apr 2005 11:24:50 -0300 (ADT) Received: from [127.0.0.1] (c-66-177-194-180.hsd1.fl.comcast.net[66.177.194.180]) by comcast.net (sccrmhc13) with ESMTP id <2005041514245501600auo33e>; Fri, 15 Apr 2005 14:24:55 +0000 Message-ID: <425FCEB4.3050802@comcast.net> Date: Fri, 15 Apr 2005 10:24:52 -0400 From: sanjay tumula Reply-To: stumula@comcast.net User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.5) Gecko/20041217 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: performance problem Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.312 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST X-Spam-Level: * X-Archive-Number: 200504/206 X-Sequence-Number: 17219 Ruud, thanx for your reply. I am narrowing down on the problem...found that Suse 9.2 has a lot of memory related problems. reverted back to 9.1 and rebuilding the app..will post an update. you suggestion will not work for me though...i need to check existing records and create new records..which cannot be done on one table. unless you are going thru hoops and doing a lot of text processing....at which point why do you need a database :-) also here is something interesting that i found regarding IN vs = on a btree index. select col1, col2 from table1 where col1 in ( 1,2,3) ; this comes right back select col1, col2 from table2 where col1 = 1 ; comes right back. select col1,col2 from table2 where col1 IN ( select col1 from table2 where col1 between 1 and 2 ) ; this takes a while.... which tells me IN is still not optimized..or am i missing something? lastly..please post to the forum and not directly to my email....so the community can see the 'whole' picture. thanx Sanjay