Re: Short-circuit sort_inner_and_outer if there are no mergejoin clauses - Mailing list pgsql-hackers

From Richard Guo
Subject Re: Short-circuit sort_inner_and_outer if there are no mergejoin clauses
Date
Msg-id CAMbWs487hyWXfiqLqeHsXWA1svvBJ=24D0jRDYWb6BogHM4gpA@mail.gmail.com
Whole thread Raw
In response to Re: Short-circuit sort_inner_and_outer if there are no mergejoin clauses  (Richard Guo <guofenglinux@gmail.com>)
List pgsql-hackers
On Fri, Apr 26, 2024 at 2:57 PM Richard Guo <guofenglinux@gmail.com> wrote:
> I doubt that there is measurable performance improvement.  But I found
> that throughout the run of the regression tests, sort_inner_and_outer is
> called a total of 44,424 times.  Among these calls, there are 11,064
> instances where mergeclause_list is found to be empty.  This accounts
> for ~1/4.  I think maybe this suggests that it's worth the shortcut as
> the patch does.

Pushed.

Thanks
Richard



pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: Suboptimal spinlock code due to volatile
Next
From: "Zhijie Hou (Fujitsu)"
Date:
Subject: RE: Conflict detection and logging in logical replication