Exclude partition constaint checking in query execution plan for partitioned table queries

Edit
ID 1264
Title Exclude partition constaint checking in query execution plan for partitioned table queries
Topic Performance
Created 2017-08-30 11:23:58
Last modified 2018-10-02 04:31:12 (6 years ago)
Latest email 2018-10-02 04:31:03 (6 years ago)
Status
2018-09: Returned with feedback
2018-07: Moved to next CF
2018-03: Moved to next CF
2018-01: Moved to next CF
2017-11: Moved to next CF
2017-09: Moved to next CF
Target version
Authors Konstantin Knizhnik (knizhnik)
Reviewers David Rowley (davidrowley), Thomas Munro (macdice)Become reviewer
Committer
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/1264
git checkout commitfest/cf/1264
Emails
Secondary index access optimizations
First at 2017-08-14 09:37:46 by Konstantin Knizhnik <k.knizhnik at postgrespro.ru>
Latest at 2018-10-02 04:31:03 by Michael Paquier <michael at paquier.xyz>
Latest attachment (skip_redundant_partition_quals.patch) at 2018-09-11 20:32:53 from Konstantin Knizhnik <k.knizhnik at postgrespro.ru>
    Attachment (skip_redundant_partition_quals.patch) at 2018-09-11 20:32:53 from Konstantin Knizhnik <k.knizhnik at postgrespro.ru> (Patch: Yes)
    Attachment (skip_redundant_partition_quals_poc.patch) at 2018-07-09 01:26:40 from David Rowley <david.rowley at 2ndquadrant.com> (Patch: Yes)
    Attachment (optimizer-11.patch) at 2018-03-22 09:38:33 from Konstantin Knizhnik <k.knizhnik at postgrespro.ru> (Patch: Yes)
    Attachment (repeat-query.sh) at 2018-03-21 17:30:08 from Konstantin Knizhnik <k.knizhnik at postgrespro.ru> (Patch: No)
    Attachment (optimizer-10.patch) at 2018-01-29 16:46:13 from Konstantin Knizhnik <k.knizhnik at postgrespro.ru> (Patch: Yes)
    Attachment (optimizer-9.patch) at 2018-01-29 13:24:42 from Konstantin Knizhnik <k.knizhnik at postgrespro.ru> (Patch: Yes)
    Attachment (optimizer-8.patch) at 2018-01-19 16:41:36 from Konstantin Knizhnik <k.knizhnik at postgrespro.ru> (Patch: Yes)
    Attachment (optimizer-7.patch) at 2018-01-11 11:59:09 from Konstantin Knizhnik <k.knizhnik at postgrespro.ru> (Patch: Yes)
    Attachment (optimizer-6.patch) at 2017-12-04 17:18:42 from Konstantin Knizhnik <k.knizhnik at postgrespro.ru> (Patch: Yes)
    Attachment (optimizer-5.patch) at 2017-12-04 16:14:57 from Konstantin Knizhnik <k.knizhnik at postgrespro.ru> (Patch: Yes)
    Attachment (optimizer-4.patch) at 2017-11-06 13:13:58 from Konstantin Knizhnik <k.knizhnik at postgrespro.ru> (Patch: Yes)
    Attachment (optimizer-3.patch) at 2017-09-07 15:58:31 from Konstantin Knizhnik <k.knizhnik at postgrespro.ru> (Patch: Yes)
    Attachment (optimizer-2.patch) at 2017-09-02 16:34:51 from Konstantin Knizhnik <k.knizhnik at postgrespro.ru> (Patch: Yes)
    Attachment (optimizer.patch) at 2017-08-16 09:23:03 from Konstantin Knizhnik <k.knizhnik at postgrespro.ru> (Patch: Yes)
History
When Who What
2018-10-02 04:31:12 Michael Paquier (michael-kun) Closed in commitfest 2018-09 with status: Returned with feedback
2018-08-10 22:50:49 Andrew Dunstan (adunstan) New status: Waiting on Author
2018-08-10 22:37:09 Andrew Dunstan (adunstan) Closed in commitfest 2018-07 with status: Moved to next CF
2018-08-10 22:37:04 Andrew Dunstan (adunstan) New status: Needs review
2018-07-09 01:27:25 David Rowley (davidrowley) New status: Waiting on Author
2018-07-09 01:27:22 David Rowley (davidrowley) Added davidrowley as reviewer
2018-04-10 12:39:35 David Steele (dsteele) Closed in commitfest 2018-03 with status: Moved to next CF
2018-03-01 04:39:43 Thomas Munro (macdice) Added macdice as reviewer
2018-02-06 22:11:35 Daniel Gustafsson (d_gustafsson) Closed in commitfest 2018-01 with status: Moved to next CF
2018-01-06 23:10:00 Stephen Frost (sfrost) New status: Needs review
2017-11-30 02:17:07 Michael Paquier (michael-kun) New status: Waiting on Author
2017-11-30 02:17:01 Michael Paquier (michael-kun) Closed in commitfest 2017-11 with status: Moved to next CF
2017-10-01 22:43:29 Daniel Gustafsson (d_gustafsson) Closed in commitfest 2017-09 with status: Moved to next CF
2017-08-30 11:24:48 Konstantin Knizhnik (knizhnik) Changed authors to Konstantin Knizhnik (knizhnik)
2017-08-30 11:23:58 Konstantin Knizhnik (knizhnik) Attached mail thread 27516421-5afa-203c-e22a-8407e9187327@postgrespro.ru
2017-08-30 11:23:58 Konstantin Knizhnik (knizhnik) Created patch record
Edit