Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id F36E89FB9CA for ; Mon, 7 May 2007 17:40:45 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 42455-06 for ; Mon, 7 May 2007 17:40:39 -0300 (ADT) X-Greylist: delayed 00:06:40.082164 by SQLgrey-1.7.5 Received: from web57103.mail.re3.yahoo.com (web57103.mail.re3.yahoo.com [216.252.111.116]) by postgresql.org (Postfix) with SMTP id A69FA9FB905 for ; Mon, 7 May 2007 17:40:41 -0300 (ADT) Received: (qmail 7589 invoked by uid 60001); 7 May 2007 20:33:59 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=umeh9iH3CKMYiUBOZCaSnG5fUa09JV36PZMZvL09yXtvwHlArDjImA92xn6qTAUXLxkgV+SI4pmaZHL3df7DHbxcqmjgr5Zo8oCz6WnOfH5Ds+LP19/AAMJkK/TsRFQuYn6lDQI+Y7ZepcBn9HNGD2EsW0yVrPoowV5L99U/8kc=; X-YMail-OSG: AM2L9SQVM1nJiyzk.uc_0DF9GXWMxIsq9NgxZ8c8AMiZUfVrkVGJN0zsItQO28xTu4Z1TcPUAfEALYo4XJUYLr8WLnnRUBeM.Rs2 Received: from [64.237.4.140] by web57103.mail.re3.yahoo.com via HTTP; Mon, 07 May 2007 13:33:59 PDT Date: Mon, 7 May 2007 13:33:59 -0700 (PDT) From: Abu Mushayeed Subject: Plannner favoring nested loop To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1421557891-1178570039=:7334" Content-Transfer-Encoding: 8bit Message-ID: <888904.7334.qm@web57103.mail.re3.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.117 tagged_above=0 required=5 tests=AWL=0.864, BAYES_00=-2.599, DNS_FROM_RFC_ABUSE=0.2, DNS_FROM_RFC_POST=1.708, DNS_FROM_RFC_WHOIS=1.447, HTML_40_50=0.496, HTML_MESSAGE=0.001 X-Spam-Level: ** X-Archive-Number: 200705/51 X-Sequence-Number: 25371 --0-1421557891-1178570039=:7334 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Hello, I am trying to determine if I can make the planner see that nested loop is very expensive while it is trying to do an plan for a query and not pick that route. Is there a way to this in postgres? I know about the "set enable..." commands. I was wondering if I can do it without the hints. Thanks Abu --------------------------------- Ahhh...imagining that irresistible "new car" smell? Check outnew cars at Yahoo! Autos. --0-1421557891-1178570039=:7334 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit
Hello,
 
I am trying to determine if I can make the planner see that nested loop is very expensive while it is trying to do an plan for a query and not pick that route.
 
Is there a way to this in postgres? I know about the "set enable..." commands. I was wondering if I can do it without the hints.
 
Thanks
Abu


Ahhh...imagining that irresistible "new car" smell?
Check out new cars at Yahoo! Autos. --0-1421557891-1178570039=:7334--