Problem with default partition pruning

Edit

Title

Topic

Bug Fixes

Created

2019-02-27 06:45:45

Last modified

2019-08-13 15:25:48 (4 years, 8 months ago)

Latest email

2019-08-14 01:12:22 (4 years, 8 months ago)

Status

2019-09: Committed

2019-07: Moved to next CF

2019-03: Moved to next CF

Target version

stable

Authors

Yuzuko Hosoya (yuzu)

Reviewers

Thibaut MADELAINE (madtibo), Ibrar Ahmed (ibrar), Shawn Wang (shawnwang)Become reviewer

Committer

Álvaro Herrera (alvherre)

Links

Emails

Problem with default partition pruning: First at 2019-02-22 08:14:04 by "Yuzuko Hosoya" <hosoya.yuzuko at lab.ntt.co.jp>
Latest at 2019-08-14 01:12:22 by Amit Langote <amitlangote09 at gmail.com>
Latest attachment (v4-0001-Rejigger-code.patch) at 2019-08-12 17:45:09 from Alvaro Herrera <alvherre at 2ndquadrant.com>
    Attachment (v4-0001-Rejigger-code.patch) at 2019-08-12 17:45:09 from Alvaro Herrera <alvherre at 2ndquadrant.com> (Patch: Yes)
    Attachment (v3-0001-Improve-RelOptInfo.partition_qual-usage.patch) at 2019-08-09 05:02:36 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Improve-RelOptInfo.partition_qual-usage.patch) at 2019-08-09 04:17:41 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (0001-Remove-duplicative-code-processing-RelOptInfo.partit.patch) at 2019-08-08 05:50:54 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (no-dupe-check.patch) at 2019-08-06 17:17:40 from Alvaro Herrera <alvherre at 2ndquadrant.com> (Patch: Yes)
    Attachment (v7_ignore_contradictory_where_clauses_at_partprune_step.patch) at 2019-08-06 13:30:53 from Alvaro Herrera <alvherre at 2ndquadrant.com> (Patch: Yes)
    Attachment (v6_ignore_contradictory_where_clauses_at_partprune_step.patch) at 2019-08-04 22:43:49 from Alvaro Herrera <alvherre at 2ndquadrant.com> (Patch: Yes)
    Attachment (v4-delta.patch) at 2019-08-04 06:29:25 from Alvaro Herrera <alvherre at 2ndquadrant.com> (Patch: Yes)
    Attachment (v4_default_partition_pruning.patch) at 2019-06-27 02:34:13 from yuzuko <yuzukohosoya at gmail.com> (Patch: Yes)
    Attachment (simplify_partquals.patch) at 2019-04-09 09:49:42 from Kyotaro HORIGUCHI <horiguchi.kyotaro at lab.ntt.co.jp> (Patch: Yes)
    Attachment (v4_ignore_contradictory_where_clauses_at_partprune_step.patch) at 2019-04-09 07:41:47 from "Yuzuko Hosoya" <hosoya.yuzuko at lab.ntt.co.jp> (Patch: Yes)
    Attachment (v3_ignore_contradictory_where_clauses_at_partprune_step.patch) at 2019-04-08 07:57:35 from "Yuzuko Hosoya" <hosoya.yuzuko at lab.ntt.co.jp> (Patch: Yes)
    Attachment (v2_ignore_contradictory_where_clauses_at_partprune_step.patch) at 2019-04-04 04:00:55 from "Yuzuko Hosoya" <hosoya.yuzuko at lab.ntt.co.jp> (Patch: Yes)
    Attachment (ignore_contradictory_where_clauses_at_partprune_step.patch) at 2019-04-02 05:02:08 from "Yuzuko Hosoya" <hosoya.yuzuko at lab.ntt.co.jp> (Patch: Yes)
    Attachment (v1-delta-2.patch) at 2019-03-22 06:02:51 from "Yuzuko Hosoya" <hosoya.yuzuko at lab.ntt.co.jp> (Patch: Yes)
    Attachment (v1-delta.patch) at 2019-03-20 09:06:13 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (remove_scan_default_from_partprune.patch) at 2019-03-19 06:27:56 from Kyotaro HORIGUCHI <horiguchi.kyotaro at lab.ntt.co.jp> (Patch: Yes)
    Attachment (v1-delta.patch) at 2019-03-18 09:44:07 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (v2_default_partition_pruning.patch) at 2019-03-15 06:05:41 from "Yuzuko Hosoya" <hosoya.yuzuko at lab.ntt.co.jp> (Patch: Yes)
    Attachment (default_partition_pruning.patch) at 2019-02-22 08:14:04 from "Yuzuko Hosoya" <hosoya.yuzuko at lab.ntt.co.jp> (Patch: Yes)

History

When	Who	What
2019-08-13 15:25:48	Álvaro Herrera (alvherre)	Closed in commitfest 2019-09 with status: Committed
2019-08-01 22:10:12	Thomas Munro (macdice)	Closed in commitfest 2019-07 with status: Moved to next CF
2019-07-31 08:17:40	Amit Langote (amitlan)	New status: Ready for Committer
2019-06-17 03:28:41	Shawn Wang (shawnwang)	Posted review with messageid <156074212109.1403.13115055299095638563.pgcf@coridan.postgresql.org>
2019-06-17 03:28:41	Shawn Wang (shawnwang)	New status: Waiting on Author
2019-06-12 08:09:36	Shawn Wang (shawnwang)	Added shawnwang as reviewer
2019-04-09 03:38:23	Michael Paquier (michael-kun)	Closed in commitfest 2019-03 with status: Moved to next CF
2019-03-14 10:55:31	Thibaut MADELAINE (madtibo)	Added madtibo as reviewer
2019-03-08 02:08:25	Álvaro Herrera (alvherre)	Changed targetversion to stable
2019-03-08 02:08:11	Álvaro Herrera (alvherre)	Added alvherre as committer
2019-03-04 17:29:00	Ibrar Ahmed (ibrar)	Posted comment with messageid <155172054069.16480.11098561831487695843.pgcf@coridan.postgresql.org>
2019-02-28 17:29:42	Ibrar Ahmed (ibrar)	Added ibrar as reviewer
2019-02-27 06:46:54	Yuzuko Hosoya (yuzu)	Changed authors to Yuzuko Hosoya (yuzu)
2019-02-27 06:45:45	Yuzuko Hosoya (yuzu)	Attached mail thread 00e601d4ca86$932b8bc0$b982a340$@lab.ntt.co.jp
2019-02-27 06:45:45	Yuzuko Hosoya (yuzu)	Created patch record

Edit