Horton

Consider parallel merge joins.

Robert Haas <rhaas@postgresql.org>

View on postgr.es
Commit: 3bc7dafa9bebbdaa1bbf0da0798d29a8bdaf6a8f
Author: Robert Haas <rhaas@postgresql.org>
Date: 2017-03-07T16:54:51Z
Releases: 10.0 
Consider parallel merge joins.

Commit 45be99f8cd5d606086e0a458c9c72910ba8a613d took the position
that performing a merge join in parallel was not likely to work out
well, but this conclusion was greeted with skepticism even at the
time.  Whether it was true then or not, it's clearly not true any
more now that we have parallel index scan.

Dilip Kumar, reviewed by Amit Kapila and by me.

Discussion: http://postgr.es/m/CAFiTN-v3=cM6nyFwFGp0fmvY4=kk79Hq9Fgu0u8CSJ-EEq1Tiw@mail.gmail.com

Files

PathChange+/−
src/backend/optimizer/path/joinpath.c modified +240 −19
src/test/regress/expected/select_parallel.out modified +25 −0
src/test/regress/sql/select_parallel.sql modified +10 −0

Discussion