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

Topic Performance

Created 2020-07-15 00:15:40

Last modified 2021-02-01 13:39:42 (3 years, 9 months ago)

Latest email 2021-02-01 03:09:12 (3 years, 9 months ago)

Status

2021-01: Returned with feedback

2020-11: Moved to next CF

2020-09: Moved to next 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 CFbot results (CirrusCI) CFbot GitHub

Checkout latest CFbot patchset

Go to your local checkout of the PostgreSQL repository and run:

git remote add commitfest https://github.com/postgresql-cfbot/postgresql.git
git fetch commitfest cf/2644
git checkout commitfest/cf/2644

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