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

From Amit Kapila
Subject pgsql: Avoid duplicate table scans for cross-partition updates during l
Date
Msg-id E1sZNnw-0028xn-Op@gemulon.postgresql.org
Whole thread Raw
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(-)


pgsql-committers by date:

Previous
From: Andres Freund
Date:
Subject: pgsql: Evaluate arguments of correlated SubPlans in the referencing Exp
Next
From: Peter Eisentraut
Date:
Subject: pgsql: Convert node test compile-time settings into run-time parameters