Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: BUG #17618: unnecessary filter column <> text even after adding index
Date
Msg-id 2100290.1663942209@sss.pgh.pa.us
Whole thread Raw
In response to BUG #17618: unnecessary filter column <> text even after adding index  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: BUG #17618: unnecessary filter column <> text even after adding index
List pgsql-bugs
Tree view 
Richard Guo <guofenglinux@gmail.com> writes:
> So I think we need to run eval_const_expressions on indexquals before we
> check for duplicate clauses, something like attached.

[ squint... ]  Surely that was done long before we ever get here?

            regards, tom lane

pgsql-bugs by date:

Previous
From: Richard Guo
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