Re: 8.3RC2 vs 8.2.6 testing results

[Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>]

"Vlad Marchenko" <marchenko(at)gmail(dot)com> writes:
> I'm curious if that new hash aggregation algorithm was put in 8.3 with the 
> performance increase as a goal

Yes.
http://archives.postgresql.org/pgsql-hackers/2007-05/msg01179.php
http://archives.postgresql.org/pgsql-committers/2007-06/msg00007.php
(and nearby messages)

> or it was simply a required change to support 
> some other new feature of 8.3? Right now the switch from 8.2 to 8.3 doesn't 
> seems a favorable step for the type of application that we have...

You are condemning a demonstrably better algorithm on the basis of one
test case.  If you poke around a bit harder you will find other cases
where it is faster than 8.2 because of having better distribution.

			regards, tom lane