Fix costing of parallel hash joins.
Peter Eisentraut <peter_e@gmx.net>
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
Files
| Path | Change | +/− |
|---|---|---|
| src/backend/optimizer/path/costsize.c | modified | +2 −0 |
| src/backend/optimizer/path/joinpath.c | modified | +1 −1 |
Discussion
- Suspicious call of initial_cost_hashjoin() 6 messages · 2017-12-22 → 2018-03-07