Re: apply_scanjoin_target_to_paths and partitionwise join

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Arne Roland <arne(dot)roland(at)malkut(dot)net>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>, Andrei Lepikhov <lepihov(at)gmail(dot)com>, Jakub Wartak <jakub(dot)wartak(at)enterprisedb(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Julien Rouhaud <rjuju123(at)gmail(dot)com>, Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com>, Richard Guo <guofenglinux(at)gmail(dot)com>
Subject: Re: apply_scanjoin_target_to_paths and partitionwise join
Date: 2025-10-29 18:55:21
Message-ID: CA+Tgmoawi-6gizOGPmR6v=GcyS8njvgED1HoW8q_=XJtMwKpZA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Oct 29, 2025 at 2:06 PM Arne Roland <arne(dot)roland(at)malkut(dot)net> wrote:
> This virtually equivalent query issue occurs when the join condition is
> (almost) unique. The different amount of tuples to process clearly
> occurs when they are not.

I'm having trouble interpreting this. If it's important, please
clarify and show an example.

--
Robert Haas
EDB: http://www.enterprisedb.com

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jonathan Gonzalez V. 2025-10-29 19:19:49 Make PGOAUTHCAFILE in libpq-oauth work out of debug mode
Previous Message Jeff Davis 2025-10-29 18:54:34 Re: C11: should we use char32_t for unicode code points?