From: Richard Guo <rguo@postgresql.org>
To: pgsql-committers@lists.postgresql.org
Subject: pgsql: Consider materializing the cheapest inner path in parallel nestl
Date: Fri, 12 Jul 2024 02:20:50 +0000
Message-ID: <E1sS5ty-001K46-A6@gemulon.postgresql.org> (raw)
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(+)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-committers@postgresql.org
Cc: rguo@postgresql.org, pgsql-committers@lists.postgresql.org
Subject: Re: pgsql: Consider materializing the cheapest inner path in parallel nestl
In-Reply-To: <E1sS5ty-001K46-A6@gemulon.postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox