Fix costing of parallel hash joins.
authorPeter Eisentraut <peter_e@gmx.net>
Wed, 7 Mar 2018 02:54:37 +0000 (21:54 -0500)
committerPeter Eisentraut <peter_e@gmx.net>
Wed, 7 Mar 2018 02:54:37 +0000 (21:54 -0500)
commit5b804cc168a52039be02f392780b9e8c8db74412
tree0bcfeb59b00f16afa2b7affc64effe0998956d28
parenta3739e376fbc9d6e332ce33d42426b1d8b59f20b
Fix costing of parallel hash joins.

Commit 1804284042e659e7d16904e7bbb0ad546394b6a3 established that single-batch
parallel-aware hash joins could create one large shared hash table using the
combined work_mem budget of all participants.  The costing accidentally
assumed that parallel-oblivious hash joins could also do that.  The
documentation for initial_cost_hashjoin() also failed to mention the new
argument.  Repair.

Author: Thomas Munro
Reported-By: Antonin Houska
Reviewed-By: Antonin Houska
Discussion: https://postgr.es/m/12441.1513935950%40localhost
src/backend/optimizer/path/costsize.c
src/backend/optimizer/path/joinpath.c