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

Поиск
Список
Период
Сортировка
Искать
От
Justin Pryzby
Тема
Re: avoid bitmapOR-ing indexes with scan condition inconsistent with partition constraint
Дата
Msg-id
20201013202031.GP9241@telsasoft.com
Ответ на
Список
Дерево обсуждения
Re: avoid bitmapOR-ing indexes with scan condition inconsistent with partition constraint Konstantin Knizhnik <knizhnik@garret.ru>
Re: avoid bitmapOR-ing indexes with scan condition inconsistent with partition constraint Tom Lane <tgl@sss.pgh.pa.us>
Re: avoid bitmapOR-ing indexes with scan condition inconsistent with partition constraint Masahiko Sawada <sawada.mshk@gmail.com>
Re: avoid bitmapOR-ing indexes with scan condition inconsistent with partition constraint Masahiko Sawada <sawada.mshk@gmail.com>
On Wed, Sep 30, 2020 at 04:52:02PM -0700, Soumyadeep Chakraborty wrote:
> 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?

Yes, thanks for doing that.  I hadn't dug into it yet to figure out what to put
where to separate the patches.  It seems like my patch handles a different goal
than Konstantin's, but they both depend on having the constraints populated.

-- 
Justin


В списке pgsql-hackers по дате отправления
От: Tom Lane
Дата:
От: Tom Lane
Дата:
FAQ