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

Edit

1264

Title

CI (CFBot)

Not processed

Stats (from CFBot)

Unknown

Topic

Performance

Tags

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 (2018-09-01 - 2018-09-30): Returned with feedback

2018-07 (2018-07-01 - 2018-07-31): Moved to different CF

2018-03 (2018-03-01 - 2018-03-31): Moved to different CF

2018-01 (2018-01-01 - 2018-01-31): Moved to different CF

2017-11 (2017-11-01 - 2017-11-30): Moved to different CF

2017-09 (2017-09-01 - 2017-09-30): Moved to different CF

Target version

Authors

Konstantin Knizhnik (knizhnik)

Reviewers

David Rowley (davidrowley), Thomas Munro (macdice)Become reviewer

Committer

Links

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