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 1vGX31-00HKR2-1A for pgsql-hackers@arkaria.postgresql.org; Wed, 05 Nov 2025 06:31:10 +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 1vGX2z-000f12-Lt for pgsql-hackers@arkaria.postgresql.org; Wed, 05 Nov 2025 06:31:08 +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 1vGX2z-000f0u-C3 for pgsql-hackers@lists.postgresql.org; Wed, 05 Nov 2025 06:31:08 +0000 Received: from mail.postgrespro.ru ([93.174.132.70]) by makus.postgresql.org with smtp (Exim 4.96) (envelope-from ) id 1vGX2t-005XFl-0U for pgsql-hackers@postgresql.org; Wed, 05 Nov 2025 06:31:07 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=postgrespro.ru; s=mx2023; t=1762324259; bh=em3hqDXy7+SuURdcv4RErgoRd716g+XnfypQm9pXFYo=; h=Date:From:To:Cc:Subject:In-Reply-To:References:Message-ID:From; b=QuNW5ZkY0WiDz1O6NaGelMaLCUXSH7I8aImcUFTrEfeAe2wRSnxT7Xda0ICEyNkVF 2caHvV2q7czhTx6E0TLnAUjcQDJfcfRXLhXsKJre95XCE+VvkvIPeSH3TkmLj9JdLR Hq0bbhDbutqgXCzs6nmrpT8If6Jvc7OIHjmiIk96wI53fFnB80EUPlEqA1R6g38x6w 4jnXWSHWaWGazUGEOP0IF5hnMWVnKMUMDa1C8DNqmLz01b1OILN3zlSiYyEmM5fgaM LI148rWu0U+oR4XF7XQSjZFkOa6bI3UNmONHzZpISxfLTMA/kpPS7t8ODdx9X25Qiu rdeOV0Qs9+zGg== Received: from mail.postgrespro.ru (webmail-slave-mstn.l.postgrespro.ru [192.168.2.28]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (2048 bits) server-digest SHA256) (Client did not present a certificate) (Authenticated sender: a.pyhalov@postgrespro.ru) by mail.postgrespro.ru (Postfix/587) with ESMTPSA id 2EAF6606B1; Wed, 5 Nov 2025 09:30:59 +0300 (MSK) MIME-Version: 1.0 Date: Wed, 05 Nov 2025 09:30:59 +0300 From: Alexander Pyhalov To: Matheus Alcantara Cc: Alena Rybakina , Pgsql Hackers Subject: Re: Asynchronous MergeAppend In-Reply-To: References: <59be194c5a409fb9fc9f2031581b8a44@postgrespro.ru> <764dd8b8-6374-4f5a-aac7-d8e3f6ebe5fd@postgrespro.ru> <159b591411bb2c81332018927acbd509@postgrespro.ru> Message-ID: <2fb1d9923b6995492e7b163e6cb95402@postgrespro.ru> X-Sender: a.pyhalov@postgrespro.ru Content-Type: text/plain; charset=UTF-8; format=flowed X-KSMG-AntiPhishing: NotDetected, bases: 2025/11/05 05:27:00 X-KSMG-AntiSpam-Interceptor-Info: not scanned X-KSMG-AntiSpam-Status: not scanned, disabled by settings X-KSMG-AntiVirus: Kaspersky Secure Mail Gateway, version 2.1.0.7854, bases: 2025/11/05 03:41:00 #27873614 X-KSMG-AntiVirus-Status: NotDetected, skipped X-KSMG-LinksScanning: not scanned, disabled by settings X-KSMG-Message-Action: skipped X-KSMG-Rule-ID: 1 Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi. Matheus Alcantara =D0=BF=D0=B8=D1=81=D0=B0=D0=BB(=D0=B0) 2025-11-03 16:00= : > So I'm +1 for the idea. I know it's been while since the last patch,=20 > and > unfortunully it hasn't received reviews since then. Do you still plan=20 > to > work on it? I still need to take a look on the code to see if I can=20 > help > with some comments. >=20 > During the tests I got compiler errors due to fce7c73fba4, so I'm > attaching a v5 with guc_parameters.dat correctly sorted. >=20 > The postgres_fdw/regress tests was also failling due to some whitespace > problems, v5 also fix this. >=20 > [1]=20 > https://www.postgresql.org/message-id/202510251154.isknefznk566%40alvhe= rre.pgsql >=20 I'm still interested in working on this patch, but it didn't get any=20 review (besides internal one). I suppose, Append and MergeAppend nodes=20 need some unification, for example, ExecAppendAsyncEventWait and=20 ExecMergeAppendAsyncEventWait looks the same, both=20 classify_matching_subplans() versions are suspiciously similar. But=20 honestly, patch needs thorough review. --=20 Best regards, Alexander Pyhalov, Postgres Professional