Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eW8mw-0004FK-Sf for pgsql-committers@arkaria.postgresql.org; Mon, 01 Jan 2018 22:42:35 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eW8mw-0005mc-Fv for pgsql-committers@arkaria.postgresql.org; Mon, 01 Jan 2018 22:42:34 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1eW8mw-0005mS-0q for pgsql-committers@lists.postgresql.org; Mon, 01 Jan 2018 22:42:34 +0000 Received: from out2-smtp.messagingengine.com ([66.111.4.26]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1eW8mt-0003Vh-B2 for pgsql-committers@postgresql.org; Mon, 01 Jan 2018 22:42:32 +0000 Received: from compute5.internal (compute5.nyi.internal [10.202.2.45]) by mailout.nyi.internal (Postfix) with ESMTP id ED3A421BFC; Mon, 1 Jan 2018 17:42:29 -0500 (EST) Received: from frontend1 ([10.202.2.160]) by compute5.internal (MEProxy); Mon, 01 Jan 2018 17:42:29 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-sender :x-me-sender:x-sasl-enc; s=fm1; bh=ZakIRhiEFaQoHfjp2ATj0JQP7IyHr mKGapje6uDrZoY=; b=AiAcO+cAvE8Kq1NanwihvBwvalY3uASMVjNs/IgAhPneA TNAl7xM8OWp/OjgDB24fRq+wjiE8VLizSRtCi3pV3xoZlMOO8SVUFYRg2vtb+Gvx QhpAiJkG0iubdYsgFxb2cKYuL4YftCnP+MySf4hoHGT7jaAvSKp+UuUonJPTpSHN +aoxaiXP3HDMOWpOKyOmrcCBQ+w8uhZA0JMWusK07J2RLq+ptd5coMlKDvj/bWMy 2PTt2FcKegyudcqOHOUieBcXrNjhFTYCb808rzovr5OaOeOyO/D6qlMv7BriuNRZ 9Zd+yt+AbFT1TBdEVZ8CTOGekZDNs9PVd7UoPSGxw== X-ME-Sender: Received: from intern.anarazel.de (unknown [136.24.76.189]) by mail.messagingengine.com (Postfix) with ESMTPA id 9D7117E139; Mon, 1 Jan 2018 17:42:29 -0500 (EST) Date: Mon, 1 Jan 2018 14:42:28 -0800 From: Andres Freund To: Thomas Munro Cc: Tom Lane , pgsql-committers Subject: Re: pgsql: Add parallel-aware hash joins. Message-ID: <20180101224228.yvmhs4onidw6gdbi@alap3.anarazel.de> References: <20171222082203.fl6rpzlqnm4h7h6h@alap3.anarazel.de> <30219.1514428346@sss.pgh.pa.us> <20171230161634.3lpvgerqsysricaa@alap3.anarazel.de> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 2017-12-31 10:59:26 +1300, Thomas Munro wrote: > On Sun, Dec 31, 2017 at 5:16 AM, Andres Freund wrote: > >> In a race case, EXPLAIN ANALYZE could fail to display correct nbatch and size > >> information. Refactor so that participants report only on batches they worked > >> on rather than trying to report on all of them, and teach explain.c to > >> consider the HashInstrumentation object from all participants instead of > >> picking the first one it can find. This should fix an occasional build farm > >> failure in the "join" regression test. > > > > This seems buggy independent of whether it fixes the issue on prairedog, > > right? So I'm inclined to go ahead and just fix it... > > +1 Pushed your updated version. Thanks, Andres