Postgres Pro
Downloads
Home   >   mailing lists

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

From David Rowley
Subject Re: Hashed IN only applied to first encountered IN
Date
Msg-id CAApHDvpmfXrcWvxpfJ7GtX=rD7L9H8Z5e6r=xXWESbR=HTJCsQ@mail.gmail.com
Whole thread Raw
In response to Hashed IN only applied to first encountered IN  (David Geier <geidav.pg@gmail.com>)
Responses Re: Hashed IN only applied to first encountered IN
List pgsql-hackers
Tree view 
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.

David

pgsql-hackers by date:

Previous
From: Alexander Korotkov
Date:
Subject: Re: Replace IN VALUES with ANY in WHERE clauses during optimization
Next
From: Robert Haas
Date:
Subject: Re: RFC: Logging plan of the running query