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 1uXUGo-00AgJF-0R for pgsql-hackers@arkaria.postgresql.org; Fri, 04 Jul 2025 00:27:14 +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 1uXUGl-00Fgg7-KY for pgsql-hackers@arkaria.postgresql.org; Fri, 04 Jul 2025 00:27:12 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uXUGl-00Fgft-Ab for pgsql-hackers@lists.postgresql.org; Fri, 04 Jul 2025 00:27:11 +0000 Received: from m16.mail.163.com ([220.197.31.5]) by makus.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1uXUGe-005Rsa-0F for pgsql-hackers@lists.postgresql.org; Fri, 04 Jul 2025 00:27:08 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=163.com; s=s110527; h=From:To:Subject:Date:Message-ID:MIME-Version: Content-Type; bh=NFEGm9wDO+a+UXtxtkiibuL8xH/vcbXr6w/dQOuTW5A=; b=LmVsYP+J6JIX4bjFB+otB385nTDi3/iMEkw6PC/h+Y55flw845F09sCInh2RMU shQkwfC64hJwT96aBiqInCxh0bTRNGy6kdWzwCRPlYwWb1ZG1A4tANQwjtNSIAFi dVxfQs2LOZbbj3my4GwT+6enFih4OZoU0oaGj7pte+qNw= Received: from lovely-coding (unknown []) by gzga-smtp-mtada-g1-2 (Coremail) with SMTP id _____wDnT4rQH2doUsvUCQ--.17884S3; Fri, 04 Jul 2025 08:26:56 +0800 (CST) From: Andy Fan To: Postgres hackers Cc: Robert Haas Subject: Re: parallel safety of correlated subquery In-Reply-To: <871pqzm5wj.fsf@163.com> (Andy Fan's message of "Wed, 02 Jul 2025 07:02:52 +0000") References: <87ecwisbk7.fsf@163.com> <87v7psqhjz.fsf@163.com> <871pqzm5wj.fsf@163.com> Date: Fri, 04 Jul 2025 08:26:55 +0800 Message-ID: <87bjq04x80.fsf@163.com> MIME-Version: 1.0 Content-Type: text/plain X-CM-TRANSID: _____wDnT4rQH2doUsvUCQ--.17884S3 X-Coremail-Antispam: 1Uf129KBjvdXoWruFW8AF1DGFy3Cw48Ww4rXwb_yoW3trc_Wr 4kJF93Wr43ArsxWwsYyry3ZF1YkrW8XF1Fga1UAr1avry5uw43Wan3u34xAr1fXw4vyFnx Cr1DJr4SvrsxJjkaLaAFLSUrUUUUjb8apTn2vfkv8UJUUUU8Yxn0WfASr-VFAUDa7-sFnT 9fnUUvcSsGvfC2KfnxnUUI43ZEXa7xR_WEE7UUUUU== X-Originating-IP: [101.227.46.168] X-CM-SenderInfo: x2klx3xlid0iqsrtqiywtou0bp/1tbioAyAU2hnHRQs+gAAsv List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Andy Fan writes: Hi, > Andy Fan writes: > > Hi, > > After some coding with this subject, I think it is better redefining > the problem and solution. .. > Hope I have made myself clear, any feedback is welcome! While I was registering this patch to commitfest, I found thread [1] which wanted to improve the exact same question, but the solution is different[2]. So anyone who is interested with this topic, probably want to have a check on [1] as well. [1] https://www.postgresql.org/message-id/CAAaqYe_x1u3V4uPiv%3DdJ%3Dk2EJ7txhdq6yexJDkYZ1x1pu0QwcQ%40mail.gmail.com [2] https://www.postgresql.org/message-id/87frfd9xqx.fsf%40163.com commitfest for this thread: https://commitfest.postgresql.org/patch/5892/ -- Best Regards Andy Fan