Re: Fast path for empty relids in check_outerjoin_delay() - Mailing list pgsql-hackers

From Richard Guo
Subject Re: Fast path for empty relids in check_outerjoin_delay()
Date
Msg-id CAN_9JTyCB_ErepYwf7obO5ax9TbPtoF-GES2_0QynH_KRpb6VQ@mail.gmail.com
Whole thread Raw
In response to Re: Fast path for empty relids in check_outerjoin_delay()  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
Responses Re: Fast path for empty relids in check_outerjoin_delay()  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers


On Fri, Jan 4, 2019 at 10:32 PM Peter Eisentraut <peter.eisentraut@2ndquadrant.com> wrote:
On 12/12/2018 08:32, Richard Guo wrote:
> This small revise is not expected to bring performance improvements, but
> can improve the readability of the code that for empty relids, the qual
> is always considered as being not-outerjoin_delayed.

I think code readability and maintainability would be improved by having
fewer special cases and fast paths.  In this particular case, I'd even
remove the existing fast path and just let the subsequent loop run zero
times.  I doubt there is a performance benefit to the existing coding.
And if there is no performance benefit, then it's not really a fast
path, just another path.

I did not find any performance data in the commit history about the
existing fast path. Not sure about its influence.

This code was added in commit d7a6a0, by Tom.
Hi Tom, what is your opinion about the fast path in
check_outerjoin_delay()?

Thanks
Richard
 

--
Peter Eisentraut              https://urldefense.proofpoint.com/v2/url?u=http-3A__www.2ndQuadrant.com_&d=DwICaQ&c=lnl9vOaLMzsy2niBC8-h_K-7QJuNJEsFrzdndhuJ3Sw&r=5r3cnfZPUDOHrMiXq8Mq2g&m=wMQ24yJUAB2h1_82PmFbMHjH-GYasxH6-zaX_8U-9NY&s=JEn98XixO6rzXoXF7dDfzSMnw2HQo_HPa0XKZntbE14&e=
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

pgsql-hackers by date:

Previous
From: Fabien COELHO
Date:
Subject: Re: commitfest: When are you assigned patches to review?
Next
From: Peter Eisentraut
Date:
Subject: Re: Displaying and dumping of table access methods