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)
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 |