pgsql: Remove redundant code in create_gather_merge_path

From: Richard Guo <rguo(at)postgresql(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Remove redundant code in create_gather_merge_path
Date: 2024-07-23 02:19:26
Message-ID: E1sW57e-000nGj-Ft@gemulon.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Remove redundant code in create_gather_merge_path

In create_gather_merge_path, we should always guarantee that the
subpath is adequately ordered, and we do not add a Sort node in
createplan.c for a Gather Merge node. Therefore, the 'else' branch in
create_gather_merge_path, which computes the cost for a Sort node, is
redundant.

This patch removes the redundant code and emits an error if the
subpath is not sufficiently ordered. Meanwhile, this patch changes
the check for the subpath's pathkeys in create_gather_merge_plan to an
Assert.

Author: Richard Guo
Discussion: https://postgr.es/m/CAMbWs48u=0bWf3epVtULjJ-=M9Hbkz+ieZQAOS=BfbXZFqbDCg@mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/8b2e9fd26afd9f379ea8bedeb4b11a354c09a3e1

Modified Files
--------------
src/backend/optimizer/plan/createplan.c | 9 ++-------
src/backend/optimizer/util/pathnode.c | 35 +++++++++++----------------------
2 files changed, 14 insertions(+), 30 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Peter Eisentraut 2024-07-23 07:24:35 pgsql: Windows replacement for strtok_r()
Previous Message Richard Guo 2024-07-23 01:34:47 pgsql: Fix rowcount estimate for gather (merge) paths