]> git.ipfire.org Git - thirdparty/postgresql.git/commit
projects / thirdparty / postgresql.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: a7f107d) | patch
Avoid duplicate table scans for cross-partition updates during logical replication.
authorAmit Kapila <akapila@postgresql.org>
Thu, 1 Aug 2024 04:41:06 +0000 (10:11 +0530)
committerAmit Kapila <akapila@postgresql.org>
Thu, 1 Aug 2024 04:41:06 +0000 (10:11 +0530)
commita67da49e1d983fc7662f7854e9eec5debbd14446
tree07885c2f9044f03c1d8e3c544526f1bad016c098tree | snapshot
parenta7f107df2b700c859e4d9ad2ca66b07a465d6223commit | diff
Avoid duplicate table scans for cross-partition updates during logical replication.

When performing a cross-partition update in the apply worker, it
needlessly scans the old partition twice, resulting in noticeable
overhead.

This commit optimizes it by removing the redundant table scan.

Author: Hou Zhijie
Reviewed-by: Hayato Kuroda, Amit Kapila
Discussion: https://postgr.es/m/OS0PR01MB571623E39984D94CBB5341D994AB2@OS0PR01MB5716.jpnprd01.prod.outlook.com
src/backend/replication/logical/worker.c diff | blob | blame | history
Mirror of https://git.postgresql.org/git/postgresql.git