pgsql: Avoid duplicate table scans for cross-partition updates during l - Mailing list pgsql-committers

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

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/a67da49e1d983fc7662f7854e9eec5debbd14446

Modified Files
--------------
src/backend/replication/logical/worker.c | 20 ++++++++++----------
1 file changed, 10 insertions(+), 10 deletions(-)