Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 76D9E9FB891 for ; Thu, 19 Apr 2007 11:20:14 -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 16736-03-5 for ; Thu, 19 Apr 2007 11:19:55 -0300 (ADT) X-Greylist: delayed 20:03:20.739011 by SQLgrey-1.7.4 Received: from mail.frii.com (phobos02.frii.com [216.17.128.162]) by postgresql.org (Postfix) with ESMTP id D055C9FB8BA for ; Thu, 19 Apr 2007 11:20:00 -0300 (ADT) Received: from kyoto.home (smcgraw.ppp.frii.com [216.17.133.158]) by mail.frii.com (FRII) with ESMTP id 5555511B5151 for ; Thu, 19 Apr 2007 08:19:59 -0600 (MDT) Received: from maxwell (maxwell.home [10.1.65.135]) by kyoto.home (Postfix) with SMTP id C304B2A65D7 for ; Thu, 19 Apr 2007 08:19:58 -0600 (MDT) From: "Stuart McGraw" To: Subject: Re: slowness when subselect uses DISTINCT Date: Thu, 19 Apr 2007 08:20:28 -0600 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.6604 (9.0.2911.0) Importance: Normal In-Reply-To: <002a01c7820b$07ee3010$9b0014ac@wbaus090> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1896 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.194 tagged_above=0 required=5 tests=AWL=0.799, BAYES_20=-0.74, FORGED_RCVD_HELO=0.135 X-Spam-Level: X-Archive-Number: 200704/165 X-Sequence-Number: 28165 Phillip Smith wrote: > May I suggest you post an EXPLAIN ANALYZE to the group for the query you're > having problems with...? I will do that but it has happened to me enough that it seems to be a general pattern, not something specific to one of my queries, so I thought some communal knowledge may exist. But apparently not.