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

Title

Topic

Performance

Created

2020-07-15 00:15:40

Last modified

2021-02-01 13:39:42 (2 years, 4 months ago)

Latest email

2021-02-01 03:09:12 (2 years, 4 months ago)

Status

2021-01: Returned with feedback

2020-11: Moved to next CF

2020-09: Moved to next CF

Target version

Authors

Soumyadeep Chakraborty (soumyadeep2007), Soumyadeep Chakraborty (soumyadeepc), Justin Pryzby (justinpryzby)

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