Re: Fix CPU cost of right-semi and right-anti hash joins

From: wenhui qiu <qiuwenhuifx(at)gmail(dot)com>
To: Richard Guo <guofenglinux(at)gmail(dot)com>
Cc: Pg Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Fix CPU cost of right-semi and right-anti hash joins
Date: 2026-08-17 03:58:46
Message-ID: CAGjGUA+G3Uo9GMvu_oC-Nv1dfj818SSByAF2y6HRt2Zj2RfOfQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi Richard

>
> > Any thoughts?
>
> The cpu_tuple_cost change looks right: RIGHT_SEMI/RIGHT_ANTI emit
> inner-side rows, while hashjointuples is based on the tuples processed
> by the hash join and can be much larger. The path LGTM
>
>
> Thanks

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message shveta malik 2026-08-17 04:02:41 Re: Support EXCEPT for TABLES IN SCHEMA publications
Previous Message Rui Zhao 2026-08-17 03:30:10 Re: Prove a NOT IN's left-hand expressions non-nullable from quals