Horton

Avoid duplicate table scans for cross-partition updates during logical replication.

Amit Kapila <akapila@postgresql.org>

View on postgr.es
Commit: a67da49e1d983fc7662f7854e9eec5debbd14446
Author: Amit Kapila <akapila@postgresql.org>
Date: 2024-08-01T04:41:06Z
Releases: 18.0 
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

Files

PathChange+/−
src/backend/replication/logical/worker.c modified +10 −10

Discussion