Re: pgsql: Add parallel-aware hash joins.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andres Freund <andres(at)anarazel(dot)de>
Cc: Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>, pgsql-committers <pgsql-committers(at)postgresql(dot)org>
Subject: Re: pgsql: Add parallel-aware hash joins.
Date: 2018-01-24 23:37:18
Message-ID: 14029.1516837038@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers

Andres Freund <andres(at)anarazel(dot)de> writes:
> On 2018-01-22 23:17:47 +1300, Thomas Munro wrote:
>> Here is a patch that halves the size of the test tables used.
>> ... Does this pass repeatedly on gaur?

> I'd say, let's just commit it and see?

Oh, sorry, I forgot I was on the hook to check that. The news isn't
good: I got one pass, and then this on the second iteration:

*** /home/postgres/pgsql/src/test/regress/expected/join.out Wed Jan 24 18:07:42 2018
--- /home/postgres/pgsql/src/test/regress/results/join.out Wed Jan 24 18:26:53 2018
***************
*** 6122,6128 ****
$$);
initially_multibatch | increased_batches
----------------------+-------------------
! t | f
(1 row)

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

rollback to settings;

======================================================================

regards, tom lane

In response to

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2018-01-24 23:46:59 Re: reducing isolation tests runtime
Previous Message Tom Lane 2018-01-24 23:35:00 Re: reducing isolation tests runtime

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2018-01-24 23:37:57 Re: [HACKERS] parallel.c oblivion of worker-startup failures
Previous Message Tom Lane 2018-01-24 23:35:00 Re: reducing isolation tests runtime