Re: BUG #17618: unnecessary filter column <> text even after adding index - Mailing list pgsql-bugs

From Richard Guo
Subject Re: BUG #17618: unnecessary filter column <> text even after adding index
Date
Msg-id CAMbWs4878nvTT=D6eECLRJqrz3+FifKr6XRSonrP0pyqmSVCLw@mail.gmail.com
Whole thread Raw
In response to Re: BUG #17618: unnecessary filter column <> text even after adding index  (Richard Guo <guofenglinux@gmail.com>)
List pgsql-bugs

On Fri, Sep 23, 2022 at 9:29 PM Richard Guo <guofenglinux@gmail.com> wrote:
So I think we need to run eval_const_expressions on indexquals before we
check for duplicate clauses, something like attached.
 
BTW, (revise to the v1 patch), if this is the right way to go, we should
do that before the foreach loop, so that we need to run
eval_const_expressions on indexquals only once rather than for each scan
clause.

Thanks
Richard

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #17618: unnecessary filter column <> text even after adding index
Next
From: Thomas Munro
Date:
Subject: Re: BUG #17619: AllocSizeIsValid violation in parallel hash join