Re: Pathify RHS unique-ification for semijoin planning

Richard Guo <guofenglinux@gmail.com>

From: Richard Guo <guofenglinux@gmail.com>

To: PostgreSQL-development <pgsql-hackers@postgresql.org>

Date: 2025-06-03T07:52:30Z

Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Simplify relation_has_unique_index_for()
- bf9ee294e567 19 (unreleased) landed
Pathify RHS unique-ification for semijoin planning
- 24225ad9aafc 19 (unreleased) landed
Convert varatt.h access macros to static inline functions.
- e035863c9a04 19 (unreleased) cited
Re-export a few of createplan.c's make_xxx() functions.
- 570be1f73f38 9.6.0 cited

Attachments

v2-0001-Pathify-RHS-unique-ification-for-semijoin-plannin.patch (application/octet-stream) patch v2-0001

On Wed, May 28, 2025 at 10:58 AM Richard Guo <guofenglinux@gmail.com> wrote:
> This patch is still a work in progress.  Before investing too much
> time into it, I'd like to get some feedback on whether it's heading in
> the right direction.

Here is an updated version of the patch, which is ready for review.
I've fixed a cost estimation issue, improved some comments, and added
a commit message.  Nothing essential has changed.

Thanks
Richard