| From: | Amit Kapila <akapila(at)postgresql(dot)org> |
|---|---|
| To: | pgsql-committers(at)lists(dot)postgresql(dot)org |
| Subject: | pgsql: Avoid duplicate table scans for cross-partition updates during l |
| Date: | 2024-08-01 04:52:44 |
| Message-ID: | E1sZNnw-0028xn-Op@gemulon.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(-)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2024-08-01 08:21:44 | pgsql: Convert node test compile-time settings into run-time parameters |
| Previous Message | Andres Freund | 2024-08-01 03:21:36 | pgsql: Evaluate arguments of correlated SubPlans in the referencing Exp |