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

Re: Speeding up aggregates

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Speeding up aggregates
Date: 2002-12-06 21:58:02
Message-ID: 200212061358.03002.josh@agliodbs.com (view raw or flat)
Thread:
Lists: pgsql-performance
Tom,

> FWIW, I've implemented hashed aggregation in CVS tip.  I have not had
> the time to try to benchmark it, but I'd be interested if anyone can
> run some tests on 7.4devel.  Eliminating the need for a SORT step
> should help aggregations over large datasets.

I'd love to, but I am still too much of a tyro to build Postgres from CVS.   
As soon as there's a tarball of 7.4devel, I'll build it and run comparisons.

-- 
-Josh Berkus
 Aglio Database Solutions
 San Francisco


In response to

Responses

pgsql-performance by date

Next:From: Tom LaneDate: 2002-12-06 23:07:08
Subject: Re: Speeding up aggregates
Previous:From: Hannu KrosingDate: 2002-12-06 21:57:31
Subject: Re: Speeding up aggregates

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