Re: avoid bitmapOR-ing indexes with scan condition inconsistent with partition constraint

Поиск
Список
Период
Сортировка
От Soumyadeep Chakraborty
Тема Re: avoid bitmapOR-ing indexes with scan condition inconsistent with partition constraint
Дата
Msg-id CAE-ML+-4EdeqH2cAYkYM9rBQasaZaGfxYbCNBe+adZvPH-wihg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: avoid bitmapOR-ing indexes with scan condition inconsistent with partition constraint  (Justin Pryzby <pryzby@telsasoft.com>)
Ответы Re: avoid bitmapOR-ing indexes with scan condition inconsistent with partition constraint  (Justin Pryzby <pryzby@telsasoft.com>)
Список pgsql-hackers
Hi Justin,

Attached is a minimal patch that is rebased and removes the
dependency on Konstantin's earlier patch[1], making it enough to remove
the extraneous index scans as Justin brought up. Is this the direction we
want to head in?

Tagging Konstantin in the email to hear his input on his old patch.
Since Justin's attached patch [1] does not include the work that was done
on the operator_predicate_proof() and as discussed here in [2], that
work is important to see real benefits? Just wanted to check before
reviewing [1].

Regards,
Soumyadeep (VMware)

[1] https://www.postgresql.org/message-id/attachment/112074/0001-Secondary-index-access-optimizations.patch
[2] https://www.postgresql.org/message-id/5A006016.1010009%40postgrespro.ru

Вложения

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: BUG #16419: wrong parsing BC year in to_date() function
Следующее
От: Fujii Masao
Дата:
Сообщение: Re: New statistics for tuning WAL buffer size