Re: BUG #17618: unnecessary filter column <> text even after adding index

Поиск
Список
Период
Сортировка
От Richard Guo
Тема Re: BUG #17618: unnecessary filter column <> text even after adding index
Дата
Msg-id CAMbWs49oBk4EfHC+44xkuAwQYnGH5pyKP40=FwZv9Zecx9=3Mg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BUG #17618: unnecessary filter column <> text even after adding index  (Richard Guo <guofenglinux@gmail.com>)
Ответы Re: BUG #17618: unnecessary filter column <> text even after adding index
Список pgsql-bugs
Дерево обсуждения

On Mon, Sep 26, 2022 at 7:42 PM Richard Guo <guofenglinux@gmail.com> wrote:
On Sat, Sep 24, 2022 at 8:41 AM Richard Guo <guofenglinux@gmail.com> wrote:
Yeah, I agree that running eval_const_expressions here is expensive.
Maybe we can just do the reverse transformation in
create_bitmap_scan_plan against what we do for boolean index in
match_boolean_index_clause?
 
Following this idea, I come up with v2 patch. Is this the right
direction to go?
 
Update with v3 patch, nothing changes except fixes a test failure
spotted by cfbot.

Thanks
Richard
Вложения

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Amit Kapila
Дата:
Сообщение: Re: BUG #17670: Logical Replication data may be lost on the subscription under certain scenarios
Следующее
От: Mike Burgener
Дата:
Сообщение: AW: BUG #17672: Wrong logic of Postgresql Resporitory Naming and mirroring incompatibility