Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 5A2449FA2BC for ; Mon, 26 Mar 2007 13:16:31 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 04966-09 for ; Mon, 26 Mar 2007 13:16:18 -0300 (ADT) X-Greylist: delayed 00:06:37.667205 by SQLgrey-1.7.4 Received: from mx2.ipf.is (scania.ipf.is [85.197.192.147]) by postgresql.org (Postfix) with ESMTP id 5E7A09FB33B for ; Mon, 26 Mar 2007 13:16:17 -0300 (ADT) Received: (qmail 26784 invoked by uid 1010); 26 Mar 2007 16:08:53 +0000 Received: from 88.149.106.19 by scania (envelope-from , uid 1008) with qmail-scanner-1.25-st-qms (clamdscan: 0.88/1235. spamassassin: 3.1.1. perlscan: 1.25-st-qms. Clear:RC:1(88.149.106.19):SA:0(-2.0/4.5):. Processed in 2.672622 secs); 26 Mar 2007 16:08:53 -0000 X-Antivirus-IPF-Mail-From: gnari@hive.is via scania X-Antivirus-IPF: 1.25-st-qms (Clear:RC:1(88.149.106.19):SA:0(-2.0/4.5):. Processed in 2.672622 secs Process 26762) Received: from dsl-149-106-19.hive.is (HELO ?192.168.1.33?) (88.149.106.19) by mx2.ipf.is with SMTP; 26 Mar 2007 16:08:50 +0000 Subject: Re: Nested Loop From: Ragnar To: Gauri Kanekar Cc: Michael Fuhr , pgsql-performance@postgresql.org In-Reply-To: <7e4ba9550703260803l16b86ef0w42182ef762837db8@mail.gmail.com> References: <7e4ba9550703260504u6e9402ferd958620c79e9640a@mail.gmail.com> <20070326140549.GA9322@winnie.fuhr.org> <7e4ba9550703260803l16b86ef0w42182ef762837db8@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1 Date: Mon, 26 Mar 2007 16:22:33 +0000 Message-Id: <1174926153.1153.31.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.8.1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/398 X-Sequence-Number: 23803 On mán, 2007-03-26 at 20:33 +0530, Gauri Kanekar wrote: you did not show your query, nor did you answer whather you had vacuumed and analyzed. > enable_seqscan = off why this? this is unlikely to help > > QUERY PLAN > ... > -> Nested Loop > (cost=0.00..1104714.83 rows=6801 width=44) (actual > time=1820.153..229779.814 rows=10945938 loops=1) the estimates are way off here. you sure you have analyzed? gnari >