Re: avoid bitmapOR-ing indexes with scan condition inconsistent with partition constraint - Mailing list pgsql-hackers

From Soumyadeep Chakraborty
Subject Re: avoid bitmapOR-ing indexes with scan condition inconsistent with partition constraint
Date
Msg-id CAE-ML+-4EdeqH2cAYkYM9rBQasaZaGfxYbCNBe+adZvPH-wihg@mail.gmail.com
Whole thread Raw
In response to Re: avoid bitmapOR-ing indexes with scan condition inconsistent with partition constraint  (Justin Pryzby <pryzby@telsasoft.com>)
Responses Re: avoid bitmapOR-ing indexes with scan condition inconsistent with partition constraint
List 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

Attachment

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: BUG #16419: wrong parsing BC year in to_date() function
Next
From: Fujii Masao
Date:
Subject: Re: New statistics for tuning WAL buffer size