| From: | Soumyadeep Chakraborty <soumyadeep2007(at)gmail(dot)com> |
|---|---|
| To: | Justin Pryzby <pryzby(at)telsasoft(dot)com> |
| Cc: | Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru>, David Rowley <dgrowleyml(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: avoid bitmapOR-ing indexes with scan condition inconsistent with partition constraint |
| Date: | 2020-09-30 23:52:02 |
| Message-ID: | CAE-ML+-4EdeqH2cAYkYM9rBQasaZaGfxYbCNBe+adZvPH-wihg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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 | Content-Type | Size |
|---|---|---|
| v3-0001-Avoid-index-scan-inconsistent-with-partition-cons.patch | text/x-patch | 6.4 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Fujii Masao | 2020-10-01 00:05:19 | Re: New statistics for tuning WAL buffer size |
| Previous Message | Bruce Momjian | 2020-09-30 23:41:47 | Re: BUG #16419: wrong parsing BC year in to_date() function |