Re: Patch: Range Merge Join - Mailing list pgsql-hackers

From Jeff Davis
Subject Re: Patch: Range Merge Join
Date
Msg-id 2a14f6f50f103773c843164ba7572fa0a2e27d9f.camel@j-davis.com
Whole thread Raw
In response to Re: Patch: Range Merge Join  (David Rowley <dgrowleyml@gmail.com>)
Responses Re: Patch: Range Merge Join
List pgsql-hackers
On Thu, 2021-06-10 at 15:09 +1200, David Rowley wrote:
> It shouldn't be a blocker for you, but just so you're aware, there
> was
> a previous proposal for this in [1] and a patch in [2].  I've include
> Jeff here just so he's aware of this. Jeff may wish to state his
> intentions with his own patch. It's been a few years now.

Great, thank you for working on this!

I'll start with the reason I set the work down before: it did not work
well with multiple join keys. That might be fine, but I also started
thinking it was specialized enough that I wanted to look into doing it
as an extension using the CustomScan mechanism.

Do you have any solution to working better with multiple join keys? And
do you have thoughts on whether it would be a good candidate for the
CustomScan extension mechanism, which would make it easier to
experiment with?

Regards,
    Jeff Davis





pgsql-hackers by date:

Previous
From: Jeff Davis
Date:
Subject: Question about StartLogicalReplication() error path
Next
From: Peter Geoghegan
Date:
Subject: Re: pg14b1 stuck in lazy_scan_prune/heap_page_prune of pg_statistic