Finish implementation of hashed aggregation. Add enable_hashagg GUC

Tom Lane <tgl@sss.pgh.pa.us>

Commit: 6c1d4662afc6344ea7d98b5d1b248214ea0c7635

Author: Tom Lane <tgl@sss.pgh.pa.us>

Date: 2002-11-21T00:42:20Z

Finish implementation of hashed aggregation.  Add enable_hashagg GUC
parameter to allow it to be forced off for comparison purposes.
Add ORDER BY clauses to a bunch of regression test queries that will
otherwise produce randomly-ordered output in the new regime.

Files

Path	Change	+/−
doc/src/sgml/runtime.sgml	modified	+12 −1
src/backend/optimizer/path/costsize.c	modified	+97 −9
src/backend/optimizer/plan/createplan.c	modified	+35 −29
src/backend/optimizer/plan/planmain.c	modified	+65 −22
src/backend/optimizer/plan/planner.c	modified	+130 −62
src/backend/utils/misc/guc.c	modified	+5 −1
src/backend/utils/misc/postgresql.conf.sample	modified	+1 −0
src/bin/psql/tab-complete.c	modified	+2 −1
src/include/optimizer/cost.h	modified	+14 −2
src/include/optimizer/planmain.h	modified	+7 −5
src/test/regress/expected/aggregates.out	modified	+4 −2
src/test/regress/expected/rangefuncs.out	modified	+2 −1
src/test/regress/expected/rules.out	modified	+2 −2
src/test/regress/expected/select_having_1.out	modified	+14 −3
src/test/regress/expected/select_having.out	modified	+6 −4
src/test/regress/expected/select_implicit_1.out	modified	+15 −11
src/test/regress/expected/select_implicit.out	modified	+15 −11
src/test/regress/expected/subselect.out	modified	+1 −1
src/test/regress/input/misc.source	modified	+1 −1
src/test/regress/output/misc.source	modified	+1 −1
src/test/regress/sql/aggregates.sql	modified	+4 −2
src/test/regress/sql/rules.sql	modified	+2 −2
src/test/regress/sql/select_having.sql	modified	+6 −5
src/test/regress/sql/select_implicit.sql	modified	+15 −11
src/test/regress/sql/subselect.sql	modified	+1 −1