Re: How to use indexes for GROUP BY

From: Dimi Paun <dimi(at)lattica(dot)com>
To: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: How to use indexes for GROUP BY
Date: 2011-01-25 05:03:26
Message-ID: 1295931806.9380.1004.camel@dimi.lattica.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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(at)lattica(dot)com>
Lattica, Inc.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Cédric Villemain 2011-01-25 13:44:17 Re: Possible to improve query plan?
Previous Message Josh Berkus 2011-01-25 02:26:16 Bloat issue on 8.3; autovac ignores HOT page splits?