avoid bitmapOR-ing indexes for scan conditions implied by partition constraint

Edit
ID 2644
Title avoid bitmapOR-ing indexes for scan conditions implied by partition constraint
CI (CFBot) Not processed
Stats (from CFBot) Unknown
Topic Performance
Tags
Created 2020-07-15 00:15:40
Last modified 2021-02-01 13:39:42 (4 years ago)
Latest email 2021-02-01 03:09:12 (4 years ago)
Status
2021-01 (2021-01-01 – 2021-01-31): Returned with feedback
2020-11 (2020-11-01 – 2020-11-30): Moved to different CF
2020-09 (2020-09-01 – 2020-09-30): Moved to different CF
Target version 14
Authors Justin Pryzby (justinpryzby), Soumyadeep Chakraborty (soumyadeep2007), Soumyadeep Chakraborty (soumyadeepc)
Reviewers Konstantin Knizhnik (knizhnik), Justin Pryzby (justinpryzby)Become reviewer
Committer Tom Lane (tgl)
Links
Emails
avoid bitmapOR-ing indexes with scan condition inconsistent with partition constraint
First at 2020-07-04 00:45:03 by Justin Pryzby <pryzby at telsasoft.com>
Latest at 2021-02-01 03:09:12 by Masahiko Sawada <sawada.mshk at gmail.com>
Latest attachment (v5-0001-prune-restrictions-using-constraints.patch) at 2020-11-12 20:14:34 from Tom Lane <tgl at sss.pgh.pa.us>
    Attachment (v5-0001-prune-restrictions-using-constraints.patch) at 2020-11-12 20:14:34 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (v3-0001-Avoid-index-scan-inconsistent-with-partition-cons.patch) at 2020-09-30 23:52:02 from Soumyadeep Chakraborty <soumyadeep2007 at gmail.com> (Patch: Yes)
    Attachment (v3-0001-Secondary-index-access-optimizations.patch) at 2020-08-03 18:12:23 from Justin Pryzby <pryzby at telsasoft.com> (Patch: Yes)
    Attachment (v2-0001-Secondary-index-access-optimizations.patch) at 2020-07-15 00:17:50 from Justin Pryzby <pryzby at telsasoft.com> (Patch: Yes)
    Attachment (0001-Secondary-index-access-optimizations.patch) at 2020-07-04 00:45:03 from Justin Pryzby <pryzby at telsasoft.com> (Patch: Yes)
History
When Who What
2021-02-01 13:39:42 Masahiko Sawada (masahikosawada) Closed in commitfest 2021-01 with status: Returned with feedback
2021-01-12 04:35:19 Justin Pryzby (justinpryzby) New status: Waiting on Author
2021-01-07 14:14:54 Masahiko Sawada (masahikosawada) New status: Needs review
2020-12-03 05:15:05 Justin Pryzby (justinpryzby) New status: Waiting on Author
2020-12-01 14:29:35 Anastasia Lubennikova (lubennikovaav) Closed in commitfest 2020-11 with status: Moved to next CF
2020-12-01 14:29:30 Anastasia Lubennikova (lubennikovaav) New status: Needs review
2020-11-12 20:26:35 Tom Lane (tgl) New status: Waiting on Author
2020-11-11 21:01:17 Justin Pryzby (justinpryzby) Changed authors to Justin Pryzby (justinpryzby), Soumyadeep Chakraborty (soumyadeep2007), Soumyadeep Chakraborty (soumyadeepc)
2020-11-11 21:00:42 Justin Pryzby (justinpryzby) Added justinpryzby as reviewer
2020-11-11 17:31:36 Tom Lane (tgl) Added tgl as committer
2020-11-11 13:36:02 Konstantin Knizhnik (knizhnik) Posted review with messageid <160510176280.7362.14687382866745492021.pgcf@coridan.postgresql.org>
2020-11-11 13:36:02 Konstantin Knizhnik (knizhnik) New status: Ready for Committer
2020-11-11 13:19:04 Konstantin Knizhnik (knizhnik) Added knizhnik as reviewer
2020-10-28 03:00:36 Justin Pryzby (justinpryzby) Changed authors to Justin Pryzby (justinpryzby)
2020-10-01 04:46:53 Michael Paquier (michael-kun) Closed in commitfest 2020-09 with status: Moved to next CF
2020-09-26 20:34:47 Justin Pryzby (justinpryzby) Changed name to avoid bitmapOR-ing indexes for scan conditions implied by partition constraint
2020-07-15 00:16:04 Justin Pryzby (justinpryzby) Changed authors to Konstantin Knizhnik (knizhnik), Justin Pryzby (justinpryzby)
2020-07-15 00:16:04 Justin Pryzby (justinpryzby) Changed targetversion to 14
2020-07-15 00:15:41 Justin Pryzby (justinpryzby) Attached mail thread 20200704004503.GA23805@telsasoft.com
2020-07-15 00:15:40 Justin Pryzby (justinpryzby) Created patch record
Edit