RE: Parallel Apply

From: "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Cc: shveta malik <shveta(dot)malik(at)gmail(dot)com>, Tomas Vondra <tomas(at)vondra(dot)me>, Dilip Kumar <dilipbalaut(at)gmail(dot)com>, Andrei Lepikhov <lepihov(at)gmail(dot)com>, wenhui qiu <qiuwenhuifx(at)gmail(dot)com>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, Peter Smith <smithpb2250(at)gmail(dot)com>, "Zhijie Hou (Fujitsu)" <houzj(dot)fnst(at)fujitsu(dot)com>
Subject: RE: Parallel Apply
Date: 2026-07-15 05:02:30
Message-ID: OS9PR01MB12149ABF7A887CDFF42038ACEF5F82@OS9PR01MB12149.jpnprd01.prod.outlook.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi hackers,

I found cfbot cannot accept the v21 patch set, please see the updated version.

Recent update: I have been working on the partition stuff discussed in [1].
Initially I've firstly implemented with the approach that does the partition
routing for every changes if the target relation was the partition root, but
found it's quite an expensive: performance degraded around 30% with my micro
benchmark. Based on that, I'm thinking with the different way.

[1]: https://www.postgresql.org/message-id/TY4PR01MB169076B157207AC056B1EA54F94D4A%40TY4PR01MB16907.jpnprd01.prod.outlook.com

Best regards,
Hayato Kuroda
FUJITSU LIMITED

Attachment Content-Type Size
v22-0001-Introduce-a-shared-hash-table-to-store-paralleli.patch application/octet-stream 9.1 KB
v22-0002-Introduce-internal-messages-to-track-dependencie.patch application/octet-stream 12.7 KB
v22-0003-Introduce-a-local-hash-table-to-store-replica-id.patch application/octet-stream 35.9 KB
v22-0004-Parallel-apply-non-streaming-transactions.patch application/octet-stream 67.9 KB
v22-0005-support-2PC.patch application/octet-stream 13.8 KB
v22-0006-Track-dependencies-for-streamed-transactions.patch application/octet-stream 10.4 KB
v22-0007-Handle-unsafe-parallel-apply-cases-due-to-non-im.patch application/octet-stream 20.1 KB
v22-0008-Support-dependency-tracking-via-local-unique-ind.patch application/octet-stream 39.8 KB
v22-0009-Support-dependency-tracking-via-local-foreign-ke.patch application/octet-stream 49.7 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Shinya Kato 2026-07-15 05:48:01 Re: Cleaning up PREPARE query strings?
Previous Message Peter Smith 2026-07-15 04:48:59 Re: Support EXCEPT for TABLES IN SCHEMA publications