Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

Next:From: C├ędric VillemainDate: 2011-01-25 13:44:17
Subject: Re: Possible to improve query plan?
Previous:From: Josh BerkusDate: 2011-01-25 02:26:16
Subject: Bloat issue on 8.3; autovac ignores HOT page splits?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group