Re: pgsql: Add parallel-aware hash joins.

Thomas Munro <thomas.munro@enterprisedb.com>

From: Thomas Munro <thomas.munro@enterprisedb.com>

To: Andres Freund <andres@anarazel.de>

Cc: Tom Lane <tgl@sss.pgh.pa.us>, pgsql-committers <pgsql-committers@postgresql.org>

Date: 2018-01-02T03:23:45Z

Lists: pgsql-hackers

On Tue, Jan 2, 2018 at 11:42 AM, Andres Freund <andres@anarazel.de> wrote:
> Pushed your updated version.

Thanks.  That should leave just the test failures like this on certain machines:

*** 6103,6109 ****
  $$);
   initially_multibatch | increased_batches
  ----------------------+-------------------
!  t                    | f
  (1 row)

  rollback to settings;
--- 6103,6109 ----
  $$);
   initially_multibatch | increased_batches
  ----------------------+-------------------
!  t                    | t
  (1 row)

I'll post a patch that should fix that along with a reply to Tom's
most recent email tomorrow, when I'm back from my break.

-- 
Thomas Munro
http://www.enterprisedb.com

Commits

Update obsolete sentence in README.parallel.
- 28e04155f17c 11.0 cited
Rewrite ConditionVariableBroadcast() to avoid live-lock.
- aced5a92bf46 11.0 cited
Tweak parallel hash join test case in hopes of improving stability.
- 934c7986f4a0 11.0 landed
Rename pg_rewind's copy_file_range() to avoid conflict with new linux syscall.
- 3e68686e2c55 11.0 cited
Fix some minor errors in new PHJ code.
- 6fcde2406304 11.0 landed
Fix EXPLAIN ANALYZE output for Parallel Hash.
- 93ea78b17c47 11.0 landed
Fix rare assertion failure in parallel hash join.
- f83040c62a78 11.0 landed
Cancel CV sleep during subtransaction abort.
- f3decdc94ea3 10.2 landed
- 59d1e2b95a82 11.0 landed
Add parallel-aware hash joins.
- 1804284042e6 11.0 cited
Fix EXPLAIN ANALYZE of hash join when the leader doesn't participate.
- 5bcf389ecfd4 11.0 cited
Add some regression tests that exercise hash join code.
- fa330f9adf4e 11.0 cited