Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1habTs-0007kZ-Fy
	for pgsql-hackers@arkaria.postgresql.org; Tue, 11 Jun 2019 07:46:08 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.89)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1habTq-0008Ex-Mj
	for pgsql-hackers@arkaria.postgresql.org; Tue, 11 Jun 2019 07:46:06 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <andres@anarazel.de>)
	id 1habTq-0008Eq-5M
	for pgsql-hackers@lists.postgresql.org; Tue, 11 Jun 2019 07:46:06 +0000
Received: from wout5-smtp.messagingengine.com ([64.147.123.21])
	by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <andres@anarazel.de>)
	id 1habTm-0007l0-40
	for pgsql-hackers@postgresql.org; Tue, 11 Jun 2019 07:46:05 +0000
Received: from compute5.internal (compute5.nyi.internal [10.202.2.45])
	by mailout.west.internal (Postfix) with ESMTP id 8CF1D48A;
	Tue, 11 Jun 2019 03:46:00 -0400 (EDT)
Received: from mailfrontend2 ([10.202.2.163])
  by compute5.internal (MEProxy); Tue, 11 Jun 2019 03:46:00 -0400
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=anarazel.de; h=
	date:from:to:cc:subject:message-id:references:mime-version
	:content-type:in-reply-to; s=fm1; bh=wqTvua/OrWpiY/NpxkMMB+X1jwJ
	qErJ7SlIzzf5Kn44=; b=5oFvxHidFxvR4FiphBSrA2DiCbe2Vj4jrJeD8Xekfge
	fG4fTWEUN3uK5I/6rGDUdjfmXNRrGx1g3TJhdErhxqETKc4oGeW629aITk+nkaNF
	X7GdmWSygbivydhhzp/R03CZvDSonvffeBF9Kv8sb40ygMmF0b3DjqArKf1FVIuD
	6HVHZJ6gyUfPpwdlbDCHCCbwh1xfTC5ogImYxzytVCMFHAeaNBj/as/PR+48IUS5
	ofdN3hUdWt+3dFfeyUucNcxqXhttnBv0unh4mehnQ87IeF4f2ISDgcvggPAFhoU/
	vbZFo0Tk83E5vd7TpnVVAvUfMVO9YTvoA+aEfSi3PzQ==
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-proxy
	:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm3; bh=wqTvua
	/OrWpiY/NpxkMMB+X1jwJqErJ7SlIzzf5Kn44=; b=Uf6HlJ0XS0lf+QW99Ygxkl
	3R2cJY2WVAKQB58Dyl/PNejdKCPok1Q01Yiyu3T+eJwVpvfwkrmrrV96rYz2BfhI
	beZGhnOlPdDlKmNZeE2P5JctDCgnAwJE5lX628gpGwgsQCCTGMam2HeNhzEktB9R
	sGOfB2NQ6GTRTndHH4sjT5LNqlbE8/OxXvaEmdvfS9255Zqe3veAZ9WUvv1mdPaJ
	EXHFnJQgCl0L6UDsPtiTm/eHrtuaY8J5IZnnD+I43mc+hdaCY5boX3SP8ycFf91P
	e8kLImdvwv+Vt6csuI8FgjUgSF+BnYLO+jGfzFcw2ax0FO0fcRBAfNRlqnodYHrw
	==
X-ME-Sender: <xms:N1z_XFke3cF0Cf5ufNa_9FOlUiDsK-ojAVu8s3o78m6VlPww5a0q1Q>
X-ME-Proxy-Cause: 
 gggruggvucftvghtrhhoucdtuddrgeduuddrudehfedguddvvdcutefuodetggdotefrod
    ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfgh
    necuuegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmd
    enucfjughrpeffhffvuffkfhggtggujgesthdtredttddtvdenucfhrhhomheptehnughr
    vghsucfhrhgvuhhnugcuoegrnhgurhgvshesrghnrghrrgiivghlrdguvgeqnecukfhppe
    eijedrudeitddrvddukedrvdefjeenucfrrghrrghmpehmrghilhhfrhhomheprghnughr
    vghssegrnhgrrhgriigvlhdruggvnecuvehluhhsthgvrhfuihiivgeptd
X-ME-Proxy: <xmx:N1z_XFHXmv0F3pv-6Cb5FS0G_R2Yw1RX-j8ZRDeBGRYkRWFhWhlTCg>
    <xmx:N1z_XGpgt5atgRT3I9-fxvLkpfPEsWYtr3gOT3dIZkTUJ4R7Fy2qvg>
    <xmx:N1z_XJ5SasmyjXElOonQiwJdtRz6UfcDLkDhK2oiw2s5w2qVmZdgeA>
    <xmx:OFz_XExO3N6rwOrQIKjVzDoasjnUBhNyN1DBS9m4KdqmxOViPpluAQ>
Received: from intern.anarazel.de (c-67-160-218-237.hsd1.ca.comcast.net
 [67.160.218.237])
	by mail.messagingengine.com (Postfix) with ESMTPA id 4E969380083;
	Tue, 11 Jun 2019 03:45:59 -0400 (EDT)
Date: Tue, 11 Jun 2019 00:45:57 -0700
From: Andres Freund <andres@anarazel.de>
To: Alexander Korotkov <a.korotkov@postgrespro.ru>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>
Subject: Re: Hash join explain is broken
Message-ID: <20190611074557.bf6wejaj6ctrjxqd@alap3.anarazel.de>
References: 
 <CAPpHfdvGVegF_TKKRiBrSmatJL2dR9uwFCuR+teQ_8tEXU8mxg@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: 
 <CAPpHfdvGVegF_TKKRiBrSmatJL2dR9uwFCuR+teQ_8tEXU8mxg@mail.gmail.com>
List-Id: <pgsql-hackers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-hackers@lists.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-hackers>
Precedence: bulk

Hi,

On 2019-06-10 21:28:12 +0300, Alexander Korotkov wrote:
> After 5f32b29c explain of Hash Join sometimes triggers an error.
>
> Simple reproduction case is below.

Thanks for finding. I've created an open issue for now.

Greetings,

Andres Freund