Re: Short-circuit sort_inner_and_outer if there are no mergejoin clauses

From: Richard Guo <guofenglinux(at)gmail(dot)com>
To: Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Short-circuit sort_inner_and_outer if there are no mergejoin clauses
Date: 2024-07-30 07:46:55
Message-ID: CAMbWs487hyWXfiqLqeHsXWA1svvBJ=24D0jRDYWb6BogHM4gpA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Apr 26, 2024 at 2:57 PM Richard Guo <guofenglinux(at)gmail(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Zhijie Hou (Fujitsu) 2024-07-30 08:19:33 RE: Conflict detection and logging in logical replication
Previous Message Heikki Linnakangas 2024-07-30 07:45:54 Re: Suboptimal spinlock code due to volatile