Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id AC0319FC33C for ; Fri, 22 Jun 2007 18:31:12 -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 60143-03 for ; Fri, 22 Jun 2007 18:31:01 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from mtao01.charter.net (mtao01.charter.net [209.225.8.186]) by postgresql.org (Postfix) with ESMTP id 4C6BA9FB372 for ; Fri, 22 Jun 2007 18:31:06 -0300 (ADT) Received: from aa03.charter.net ([10.20.200.155]) by mtao01.charter.net (InterMail vM.7.08.02.00 201-2186-121-20061213) with ESMTP id <20070622213058.MAKY1445.mtao01.charter.net@aa03.charter.net>; Fri, 22 Jun 2007 17:30:58 -0400 Received: from [10.0.1.2] (really [66.188.164.45]) by aa03.charter.net with ESMTP id <20070622213058.BFIZ7864.aa03.charter.net@[10.0.1.2]>; Fri, 22 Jun 2007 17:30:58 -0400 In-Reply-To: References: Mime-Version: 1.0 (Apple Message framework v752.2) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: Cc: pgsql-performance@postgresql.org Content-Transfer-Encoding: 7bit From: Michael Glaesemann Subject: Re: Slow join query Date: Fri, 22 Jun 2007 16:30:56 -0500 To: "Tom Tamulewicz" X-Mailer: Apple Mail (2.752.2) X-Chzlrs: 0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/550 X-Sequence-Number: 25583 [Please don't top post as it makes the discussion more difficult to follow.] On Jun 22, 2007, at 16:25 , Tom Tamulewicz wrote: > The explain is as follows... EXPLAIN ANALYZE, please. (And for convenience, it helps if you include the query :) ) Michael Glaesemann grzm seespotcode net