Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nWSh0-00039e-Ef for pgsql-hackers@arkaria.postgresql.org; Tue, 22 Mar 2022 00:48:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nWSgz-00046n-AD for pgsql-hackers@arkaria.postgresql.org; Tue, 22 Mar 2022 00:48:09 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nWSgz-00046Y-1C for pgsql-hackers@lists.postgresql.org; Tue, 22 Mar 2022 00:48:09 +0000 Received: from out5-smtp.messagingengine.com ([66.111.4.29]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nWSgw-0000TA-Nw for pgsql-hackers@postgresql.org; Tue, 22 Mar 2022 00:48:08 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.nyi.internal (Postfix) with ESMTP id 300725C0243; Mon, 21 Mar 2022 20:48:06 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute4.internal (MEProxy); Mon, 21 Mar 2022 20:48:06 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=anarazel.de; h= cc:cc:content-type:date:date:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:sender:subject :subject:to:to; s=fm1; bh=xmU+1FNtttYxYxvNzbiZ5MuRjq77+1mJUvkg9e rgapQ=; b=Exzt7G0DQXR0LNmN1y3IRjSTSNoG85K3BxMd18TZqslr+GMiRY80gd z7TPKYlEIj22vpOShOOg7mShplQcoUvK9oD+C3d5bdAqFaLkxefganHbEtgB2P/X NzWB1VGkayxxQAwz9IKvlUuVeQtIsm7XYFGMaKI3oXIHDepCgvgR9f+/7T9zKm75 yDh8omnItWpaB9H+fcD3G+adcuY2IGs5miySRXwhPq3FWq19gdiTUdXNVaLuMB9c +WaS7DmsRhV9OlRDPK8PT/ECJzFy7AaXHoVASAN8vn4wAeuoFxEFH4vQW3cVKTTy fDwRtjn/pkQURbkRlmmuCa1WBz4vU60g== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-type:date:date:from:from :in-reply-to:in-reply-to:message-id:mime-version:references :reply-to:sender:subject:subject:to:to:x-me-proxy:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm3; bh=xmU+1FNtttYxYxvNz biZ5MuRjq77+1mJUvkg9ergapQ=; b=AnlkfiIRpqsbc/iQ5vIJDDPlqv7m8nx5Y 8TeKaUX9/2r7SDpC4JzBLaQMSEUtJnWZLNk8z4TYq63ZDhHpJrSGYsPRW+7kKO2C QhhgyQYyigXxBbgSQUfVYintwKEkp2HC5zVPDuB7Rr9/vbmiWryBDdnPaNbrKrXA i5WCLDPCMahC//Dc2vX5upJDkyy1fMYSLpzs8TA4nE0/BdlmziVD5b9MZjGO+P38 c/xx7lfSBRvOANnU8pSPqIRNugNUh0WPxFqf9rW01HTpquSUiTmp5v9fbl+F8JIP A2d6v3H7ciNLIpzuE3zHQ8E9ZYdzHgRZj7JYI1YiH6CeJm0RoiUiw== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvvddrudeggedgvdeiucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne cujfgurhepfffvuffkfhggtggujgfhsehttdertddttddvnecuhfhrohhmpeetnhgurhgv shcuhfhrvghunhguuceorghnughrvghssegrnhgrrhgriigvlhdruggvqeenucggtffrrg htthgvrhhnpeehgfeljeehudejieeljeekgfefheejkeeuheetgfejleefteegleduudeh iedvkeenucffohhmrghinheptghirhhruhhsqdgtihdrtghomhenucevlhhushhtvghruf hiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpegrnhgurhgvshesrghnrghrrgii vghlrdguvg X-ME-Proxy: Received: by mail.messagingengine.com (Postfix) with ESMTPA; Mon, 21 Mar 2022 20:48:05 -0400 (EDT) Date: Mon, 21 Mar 2022 17:48:05 -0700 To: James Coleman Cc: Robert Haas , pgsql-hackers , Amit Kapila , Tom Lane Subject: Re: Parallelize correlated subqueries that execute within each worker Message-ID: <20220322004805.vwmgjp62tq3mj2oq@alap3.anarazel.de> [IFrom: Andres Freund References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: From: Andres Freund List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, On 2022-01-22 20:25:19 -0500, James Coleman wrote: > On the other hand this is a dramatically simpler patch series. > Assuming the approach is sound, it should much easier to maintain than > the previous version. > > The final patch in the series is a set of additional checks I could > imagine to try to be more explicit, but at least in the current test > suite there isn't anything at all they affect. > > Does this look at least somewhat more like what you'd envisionsed > (granting the need to squint hard given the relids checks instead of > directly checking params)? This fails on freebsd (so likely a timing issue): https://cirrus-ci.com/task/4758411492458496?logs=test_world#L2225 Marked as waiting on author. Greetings, Andres Freund