Re: Hashed IN only applied to first encountered IN - Mailing list pgsql-hackers

From David Geier
Subject Re: Hashed IN only applied to first encountered IN
Date
Msg-id 90f12d4a-e8b2-405a-9907-5bf205167961@gmail.com
Whole thread Raw
In response to Re: Hashed IN only applied to first encountered IN  (David Rowley <dgrowleyml@gmail.com>)
List pgsql-hackers
Great!

Thank you!

On 4/2/2025 1:00 AM, David Rowley wrote:
> On Wed, 2 Apr 2025 at 01:31, David Rowley <dgrowleyml@gmail.com> wrote:
>> On Wed, 2 Apr 2025 at 00:51, David Geier <geidav.pg@gmail.com> wrote:
>>> The hashed IN optimization is only applied to the first encountered
>>> ScalarArrayOpExpr during the expression tree traversal in
>>> convert_saop_to_hashed_saop_walker(). Reason being that the walker
>>> returns true which aborts the traversal.
>>> I've also attached a patch with a fix.
>> Thanks for the report and fix.  On first inspection your patch looks
>> fine.  I'll have a closer look tomorrow.
> I've now pushed and backpatched the relevant portion of this back to v14.
>
> Thanks again.
>
> David



pgsql-hackers by date:

Previous
From: Ilia Evdokimov
Date:
Subject: Re: Add estimated hit ratio to Memoize in EXPLAIN to explain cost adjustment
Next
From: Ashutosh Bapat
Date:
Subject: Re: statistics import and export: another difference in dump/restore