Postgres Pro
Downloads
Home   >   mailing lists

Re: any hope for my big query? - Mailing list pgsql-performance

From Simon Riggs
Subject Re: any hope for my big query?
Date
Msg-id 1159527683.2767.298.camel@holly
Whole thread Raw
In response to any hope for my big query?  (Ben <bench@silentmedia.com>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Simon Riggs
Date:
Subject: Re: archive wal's failure and load increase.
Next
From: Markus Schaber
Date:
Subject: Re: Performace Optimization for Dummies