Received: from maia.hub.org (maia-5.hub.org [200.46.204.29])
	by mail.postgresql.org (Postfix) with ESMTP id 74AFF1337B8B
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Tue, 25 Jan 2011 01:03:50 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024)
	with ESMTP id 65036-02
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Tue, 25 Jan 2011 05:03:43 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from ulysses.lattica.com (lattica.com [204.14.19.114])
	by mail.postgresql.org (Postfix) with ESMTP id 18F5C1337B58
	for <pgsql-performance@postgresql.org>;
	Tue, 25 Jan 2011 01:03:43 -0400 (AST)
Received: from localhost (ulysses.lattica.com [127.0.0.1])
	by ulysses.lattica.com (Postfix) with ESMTP id 59E89EA4004;
	Tue, 25 Jan 2011 00:03:39 -0500 (EST)
X-Virus-Scanned: amavisd-new at lattica.com
Received: from ulysses.lattica.com ([127.0.0.1])
	by localhost (ulysses.lattica.com [127.0.0.1]) (amavisd-new, port 10024)
	with ESMTP id H3hLErz-oOhn; Tue, 25 Jan 2011 00:03:27 -0500 (EST)
Received: from [192.168.3.11]
	(CPE00104b0b2be4-CM00222d5a2acd.cpe.net.cable.rogers.com
	[99.255.186.187])
	by ulysses.lattica.com (Postfix) with ESMTP id 5BC9FEA4001;
	Tue, 25 Jan 2011 00:03:27 -0500 (EST)
Subject: Re: How to use indexes for GROUP BY
From: Dimi Paun <dimi@lattica.com>
To: Scott Marlowe <scott.marlowe@gmail.com>
Cc: "pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>
In-Reply-To: <AANLkTimcRtF6TmeFJO2OWByB_uaqRDoo5HTx1oVRF5X4@mail.gmail.com>
References: <1295893741.9380.984.camel@dimi.lattica.com>
	<AANLkTimcRtF6TmeFJO2OWByB_uaqRDoo5HTx1oVRF5X4@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
Organization: Lattica, Inc.
Date: Tue, 25 Jan 2011 00:03:26 -0500
Message-ID: <1295931806.9380.1004.camel@dimi.lattica.com>
Mime-Version: 1.0
X-Mailer: Evolution 2.32.1 (2.32.1-1.fc14) 
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9,
	T_RP_MATCHES_RCVD=-0.01
X-Spam-Level: 
X-Archive-Number: 201101/229
X-Sequence-Number: 42016

On Mon, 2011-01-24 at 12:33 -0700, Scott Marlowe wrote:
> As another poster observed, you're running an ancient version of pgsql
> from a performance perspective.  Upgrading to 8.4 or 9.0 would make a
> huge difference in overall performance, not just with one or two
> queries. 

Thanks for the trips.

I'll try to first upgrade, and I'll report back if that doesn't help :)

-- 
Dimi Paun <dimi@lattica.com>
Lattica, Inc.