From: | Richard Guo <rguo(at)postgresql(dot)org> |
---|---|
To: | pgsql-committers(at)lists(dot)postgresql(dot)org |
Subject: | pgsql: Consider materializing the cheapest inner path in parallel nestl |
Date: | 2024-07-12 02:20:50 |
Message-ID: | E1sS5ty-001K46-A6@gemulon.postgresql.org |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers |
Consider materializing the cheapest inner path in parallel nestloop
When generating non-parallel nestloop paths for each available outer
path, we always consider materializing the cheapest inner path if
feasible. Similarly, in this patch, we also consider materializing
the cheapest inner path when building partial nestloop paths. This
approach potentially reduces the need to rescan the inner side of a
partial nestloop path for each outer tuple.
Author: Tender Wang
Reviewed-by: Richard Guo, Robert Haas, David Rowley, Alena Rybakina
Reviewed-by: Tomasz Rybak, Paul Jungwirth, Yuki Fujii
Discussion: https://postgr.es/m/CAHewXNkPmtEXNfVQMou_7NqQmFABca9f4etjBtdbbm0ZKDmWvw@mail.gmail.com
Branch
------
master
Details
-------
https://git.postgresql.org/pg/commitdiff/22d946b0f86f9c13f869bb8b75444a77a20134d8
Modified Files
--------------
src/backend/optimizer/path/joinpath.c | 25 ++++++++++++++++++++++
src/test/regress/expected/select_parallel.out | 30 +++++++++++++++++++++++++++
src/test/regress/sql/select_parallel.sql | 10 +++++++++
3 files changed, 65 insertions(+)
From | Date | Subject | |
---|---|---|---|
Next Message | Amit Kapila | 2024-07-12 04:34:28 | pgsql: Fix unstable test in 040_pg_createsubscriber. |
Previous Message | Thomas Munro | 2024-07-12 00:56:33 | pgsql: Disable clang 16's -Wcast-function-type-strict. |