Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 47C159FB1C2 for ; Fri, 29 Sep 2006 08:01:37 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 15198-06 for ; Fri, 29 Sep 2006 11:01:34 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sand1.gxn.net (sand1.gxn.net [195.147.249.207]) by postgresql.org (Postfix) with ESMTP id D6A1B9FAC9B for ; Fri, 29 Sep 2006 08:01:33 -0300 (ADT) Received: from [62.232.55.86] (helo=[192.168.0.26]) by sand1.gxn.net with esmtp (Exim 4.50) id 1GTGDP-0004yI-Ev; Fri, 29 Sep 2006 12:07:36 +0100 Subject: Re: any hope for my big query? From: Simon Riggs To: Ben Cc: pgsql-performance@postgresql.org In-Reply-To: References: Content-Type: text/plain Date: Fri, 29 Sep 2006 12:01:23 +0100 Message-Id: <1159527683.2767.298.camel@holly> Mime-Version: 1.0 X-Mailer: Evolution 2.6.2 (2.6.2-1.fc5.5) Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200609/424 X-Sequence-Number: 21110 On Thu, 2006-09-28 at 15:18 -0700, Ben wrote: > distinct public.album.id > group by public.album.id You can remove the distinct clause for starters... -- Simon Riggs EnterpriseDB http://www.enterprisedb.com