pgsql: Fix costing of parallel hash joins.

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Fix costing of parallel hash joins.
Date: 2018-03-07 02:56:05
Message-ID: E1etPFN-0001ft-Gg@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

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

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/5b804cc168a52039be02f392780b9e8c8db74412

Modified Files
--------------
src/backend/optimizer/path/costsize.c | 2 ++
src/backend/optimizer/path/joinpath.c | 2 +-
2 files changed, 3 insertions(+), 1 deletion(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Stephen Frost 2018-03-07 04:36:34 pgsql: Fix typo for RangeVarGetRelidExtended
Previous Message Peter Eisentraut 2018-03-07 02:48:04 pgsql: doc: Improve calculation of vm.nr_hugepages