pgsql: Revise hash join code so that we can increase the number of

From: tgl(at)svr1(dot)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Revise hash join code so that we can increase the number of
Date: 2005-03-06 22:15:05
Message-ID: 20050306221505.933CC550E7@svr1.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Log Message:
-----------
Revise hash join code so that we can increase the number of batches
on-the-fly, and thereby avoid blowing out memory when the planner has
underestimated the hash table size. Hash join will now obey the
work_mem limit with some faithfulness. Per my recent proposal
(hash aggregate part isn't done yet though).

Modified Files:
--------------
pgsql/src/backend/executor:
nodeHash.c (r1.88 -> r1.89)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/executor/nodeHash.c.diff?r1=1.88&r2=1.89)
nodeHashjoin.c (r1.67 -> r1.68)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/executor/nodeHashjoin.c.diff?r1=1.67&r2=1.68)
pgsql/src/backend/optimizer/path:
costsize.c (r1.137 -> r1.138)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/path/costsize.c.diff?r1=1.137&r2=1.138)
pgsql/src/backend/utils/adt:
selfuncs.c (r1.171 -> r1.172)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/selfuncs.c.diff?r1=1.171&r2=1.172)
pgsql/src/include/executor:
hashjoin.h (r1.34 -> r1.35)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/executor/hashjoin.h.diff?r1=1.34&r2=1.35)
nodeHash.h (r1.35 -> r1.36)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/executor/nodeHash.h.diff?r1=1.35&r2=1.36)
nodeHashjoin.h (r1.28 -> r1.29)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/executor/nodeHashjoin.h.diff?r1=1.28&r2=1.29)
pgsql/src/include/nodes:
execnodes.h (r1.122 -> r1.123)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/nodes/execnodes.h.diff?r1=1.122&r2=1.123)
pgsql/src/include/utils:
selfuncs.h (r1.21 -> r1.22)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/utils/selfuncs.h.diff?r1=1.21&r2=1.22)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2005-03-07 02:00:28 pgsql: Add a note that regression test row ordering differences can be
Previous Message User Dpavlin 2005-03-06 21:20:26 pgswish - pgswish: subversion revision 19 commited to CVS