Re: Pathify RHS unique-ification for semijoin planning - Mailing list pgsql-hackers

From Richard Guo
Subject Re: Pathify RHS unique-ification for semijoin planning
Date
Msg-id CAMbWs49MiHSUCgoGKGBws7Xs4hMD8Me7HVkNZ7WuMfNgfC6Z0Q@mail.gmail.com
Whole thread Raw
In response to Re: Pathify RHS unique-ification for semijoin planning  (Richard Guo <guofenglinux@gmail.com>)
Responses Re: Pathify RHS unique-ification for semijoin planning
List pgsql-hackers
On Mon, Aug 4, 2025 at 11:08 AM Richard Guo <guofenglinux@gmail.com> wrote:
> The v5 patch does not apply anymore, and here is a new rebase.  There
> are two main changes in v6:
>
> * I choose to use the check I proposed earlier to determine whether a
> relation has been unique-ified in costsize.c.
>
> * Now that the only call to relation_has_unique_index_for() that
> supplied an exprlist and oprlist has been removed, the loop handling
> those lists is effectively dead code.  0002 removes that loop and
> simplifies the function accordingly.

Does anyone plan to review this patch further?  I intend to push it in
two weeks unless there are any objections or additional comments.

Thanks
Richard



pgsql-hackers by date:

Previous
From: Joseph Koshakow
Date:
Subject: Re: date_trunc invalid units with infinite value
Next
From: Chao Li
Date:
Subject: Re: Patch 1 of GB18030-2022 support