"Josh Berkus" <josh(at)agliodbs(dot)com> writes:
> What have other Postgres users done to speed up aggregates on large
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.
Note that even though there's no SORT, the sort_mem setting is used
to determine the allowable hashtable size, so a too-small sort_mem
might discourage the planner from selecting hashed aggregation.
Use EXPLAIN to see which query plan gets chosen.
regards, tom lane
In response to
pgsql-performance by date
|Next:||From: Tom Lane||Date: 2002-12-06 21:05:00|
|Subject: Re: ALTER TABLE .. < ADD | DROP > OIDS |
|Previous:||From: Rod Taylor||Date: 2002-12-06 20:35:32|
|Subject: Re: ALTER TABLE .. < ADD | DROP > OIDS|