Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rUrNq-00DQ1y-O5 for pgsql-hackers@arkaria.postgresql.org; Tue, 30 Jan 2024 16:54:51 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rUrNp-0080sA-Pr for pgsql-hackers@arkaria.postgresql.org; Tue, 30 Jan 2024 16:54:49 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rUrNp-0080s2-Gh for pgsql-hackers@lists.postgresql.org; Tue, 30 Jan 2024 16:54:49 +0000 Received: from mail-ej1-x629.google.com ([2a00:1450:4864:20::629]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rUrNm-004YhK-Ek for pgsql-hackers@lists.postgresql.org; Tue, 30 Jan 2024 16:54:48 +0000 Received: by mail-ej1-x629.google.com with SMTP id a640c23a62f3a-a35e65df2d8so263485366b.0 for ; Tue, 30 Jan 2024 08:54:46 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1706633686; x=1707238486; darn=lists.postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=DS8qEY/Z/W3RgWRpSY+Ots3Zmpv02BQ8T8/FPoMZ+Ts=; b=ZaQltATmpGTK9q9Hjmfl7EX+rCj+p6A/uCRLiV4Lbmg71TtpsGMBXIgEB4hvXJKFXa JGRs5cPaezUfaZpU4CEwUMYGZWDnaNqq3BQrZEqiKCY25txGpDiaia4tPkY5o9nIqxWS QSnJoMEu6IwFgqKKoa+dyFv6+cy2IGxnKKUIH+/vYBw9quwWKeimD67vaANWQeS7K1TS 3DGqqvBTf2kHorpwqONVpsRH4Cd5q5dp9L+pO1ZZjkBvvhV7iCV3VYnVcUg5116pqPey PvhXjhUiwHK9L0motT1rVZG733qOy2XhXD8t5KEO4DE3MbhCaXlOsYb3u/eRIJoHfP2O DG3Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1706633686; x=1707238486; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=DS8qEY/Z/W3RgWRpSY+Ots3Zmpv02BQ8T8/FPoMZ+Ts=; b=xAN5zEPa8M7cVvu5J5pkLj/nqWb8eAg3NWY5BzLuoiI9pTPCoZBRfv1rGo31c22Iij R6a3YRUeljnygPsVwHkpR3Ai2uvN5R6udTnMczVuGHdwjp5tjXR6wrr844mP+/rEjR8z LfYmDdmiQQwF1ctJpTkEw7QvM/9ZE8g7/0UQi4DyR7RTv3ny+lqZ2ur3HONmXgoCaTKo 1EAPiRlkfvkGqSzhzEFhKOn3qyAowexdjZYN76mupFuQsHSXTm7Gr+Pz/0lRGDnMPMs2 ZPD6pKkOGqpp3pPTV+4UHsNomLgMuCCpKkSjOu+CG/h7xAs+LxA8t4Mn4q+e/wcDnHGy kPyw== X-Gm-Message-State: AOJu0YwuKwLxoqc7ZBZ6KUduD5phiLbAmdygkRBmBIyZuk43mMI8xfiD XzSLaLyLHGRhbfeBTpwuDW+vOAirjGjpy95wEVQu6sTt3WfIUogQZ4Ch1CIo6Frs3XG2BpCXi4l lpIljyFqPt5dfaeBjL3IW2GasrYSrSlkY X-Google-Smtp-Source: AGHT+IFNObBPBf1k/p7jeOVEPPKTFUpvAB22UtCL6oGbS8KQqA6o4hFKadYQ1w4Zunf3VxSeSk0fxAtwNVRfBL/Ww1U= X-Received: by 2002:a17:906:ca92:b0:a31:3a5d:c853 with SMTP id js18-20020a170906ca9200b00a313a5dc853mr6485202ejb.49.1706633685733; Tue, 30 Jan 2024 08:54:45 -0800 (PST) MIME-Version: 1.0 References: <170663138007.1131.9149309283833230346.pgcf@coridan.postgresql.org> In-Reply-To: <170663138007.1131.9149309283833230346.pgcf@coridan.postgresql.org> From: Robert Haas Date: Tue, 30 Jan 2024 11:54:34 -0500 Message-ID: Subject: Re: Parallelize correlated subqueries that execute within each worker To: Akshat Jaimini Cc: pgsql-hackers@lists.postgresql.org, James Coleman Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, Jan 30, 2024 at 11:17=E2=80=AFAM Akshat Jaimini wrote: > I think we should move this patch to the next CF as I believe that work i= s still going on resolving the last reported bug. We shouldn't just keep pushing this forward to the next CF. It's been idle since July. If it needs more work, mark it RwF and it can be reopened when there's something for a reviewer to do. --=20 Robert Haas EDB: http://www.enterprisedb.com