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, 1 month ago)

Latest email 2018-10-02 04:31:03 (6 years, 1 month 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