Problem with default partition pruning

Edit

ID 2029

Title Problem with default partition pruning

Topic Bug Fixes

Created 2019-02-27 06:45:45

Last modified 2019-08-13 15:25:48 (5 years, 3 months ago)

Latest email 2019-08-14 01:12:22 (5 years, 3 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 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/2029
git checkout commitfest/cf/2029

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