Speed up planning with partitions

Edit

Title

Topic

Performance

Created

2018-08-30 01:08:56

Last modified

2019-04-01 04:23:45 (4 years, 2 months ago)

Latest email

2019-04-05 10:47:47 (4 years, 2 months ago)

Status

2019-03: Committed

2019-01: Moved to next CF

2018-11: Moved to next CF

2018-09: Moved to next CF

Target version

Authors

Amit Langote (amitlan)

Reviewers

David Rowley (davidrowley), Dilip Kumar (dilip.kumar), Yoshikazu Imai (yimai), Jesper Pedersen (jpedersen)Become reviewer

Committer

Tom Lane (tgl)

Links

Emails

speeding up planning with partitions: First at 2018-08-29 12:06:16 by Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp>
Latest at 2019-04-05 10:47:47 by David Rowley <david.rowley at 2ndquadrant.com>
Latest attachment (Update-docs-that-update-delete-no-longer-use-cons.patch) at 2019-04-05 06:50:25 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp>
    Attachment (Update-docs-that-update-delete-no-longer-use-cons.patch) at 2019-04-05 06:50:25 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (HEAD-get_relation_constraints-fix_v2.patch) at 2019-04-02 05:50:59 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (regression.diffs) at 2019-04-01 17:34:45 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (HEAD-get_relation_constraints-fix.patch) at 2019-04-01 10:02:44 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (dont-iterate-over-otherrels-if-we-dont-have-to-1.patch) at 2019-03-31 18:46:51 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (live_parts.diff) at 2019-03-31 02:45:54 from Imai Yoshikazu <yoshikazu_i443 at live.jp> (Patch: Yes)
    Attachment (0001-avoid-geqo-crash-with-partitionwise-join.patch) at 2019-03-30 00:17:32 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (speed-up-planning-with-partitions-38.patch) at 2019-03-28 22:38:04 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (v37-0001-Delay-adding-inheritance-child-tables-until-quer.patch) at 2019-03-27 03:06:04 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (v36-0001-Build-other-rels-of-appendrel-baserels-in-a-sepa.patch) at 2019-03-26 07:16:41 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (v35-0001-Build-other-rels-of-appendrel-baserels-in-a-sepa.patch) at 2019-03-25 11:34:45 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (looping-over-last-baserel-idx.diff) at 2019-03-25 01:47:23 from "Imai, Yoshikazu" <imai.yoshikazu at jp.fujitsu.com> (Patch: Yes)
    Attachment (v34-0001-Build-other-rels-of-appendrel-baserels-in-a-sepa.patch) at 2019-03-22 07:39:30 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (v33-0001-Build-other-rels-of-appendrel-baserels-in-a-sepa.patch) at 2019-03-20 00:41:43 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (v32-0001-Build-other-rels-of-appendrel-baserels-in-a-sepa.patch) at 2019-03-19 06:53:19 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (v31-0001-Build-other-rels-of-appendrel-baserels-in-a-sepa.patch) at 2019-03-12 14:33:57 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (regression.diff.txt) at 2019-03-12 13:23:25 from Jesper Pedersen <jesper.pedersen at redhat.com> (Patch: Yes)
    Attachment (v30-0001-Build-other-rels-of-appendrel-baserels-in-a-sepa.patch) at 2019-03-12 08:22:59 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (v29-0001-Build-other-rels-of-appendrel-baserels-in-a-sepa.patch) at 2019-03-08 09:18:00 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (v26-0003-solving-memory-increasement-problem.diff) at 2019-03-08 07:16:30 from "Imai, Yoshikazu" <imai.yoshikazu at jp.fujitsu.com> (Patch: Yes)
    Attachment (v28-0001-Build-other-rels-of-appendrel-baserels-in-a-sepa.patch) at 2019-03-08 06:26:55 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (v27-0001-Build-other-rels-of-appendrel-baserels-in-a-sepa.patch) at 2019-03-05 10:24:26 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (v26-0001-Build-other-rels-of-appendrel-baserels-in-a-sepa.patch) at 2019-03-04 10:38:34 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (v25-0001-Lazy-creation-of-RTEs-for-inheritance-children.patch) at 2019-03-01 13:01:31 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (v24-0003-Do-not-lock-all-partitions-at-the-beginning.patch) at 2019-02-22 17:54:35 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v23-0001-Lazy-creation-of-RTEs-for-inheritance-children.patch) at 2019-02-22 12:45:38 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (0001-Overhaul-inheritance-update-delete-planning.patch) at 2019-02-19 10:42:49 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: No)
    Attachment (v22-0001-Reduce-code-duplication-in-set_append_rel_size.patch) at 2019-02-12 06:41:15 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (v21-0001-Reduce-code-duplication-in-set_append_rel_size.patch) at 2019-02-08 09:12:34 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (v20-0001-Overhaul-inheritance-update-delete-planning.patch) at 2019-02-07 10:21:45 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: No)
    Attachment (faster-locallock-scan.patch) at 2019-02-06 02:03:34 from "Tsunakawa, Takayuki" <tsunakawa.takay at jp.fujitsu.com> (Patch: Yes)
    Attachment (v19-0004-Do-not-lock-all-partitions-at-the-beginning.patch) at 2019-02-02 13:52:37 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (0001-Move-building-of-child-base-quals-out-into-a-new-fun.patch) at 2019-01-30 19:32:16 from David Rowley <david.rowley at 2ndquadrant.com> (Patch: Yes)
    Attachment (v18-0001-Overhaul-inheritance-update-delete-planning.patch) at 2019-01-29 09:32:27 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: No)
    Attachment (v17_fixup.diff) at 2019-01-28 04:18:02 from David Rowley <david.rowley at 2ndquadrant.com> (Patch: Yes)
    Attachment (v17-0001-Overhaul-inheritance-update-delete-planning.patch) at 2019-01-23 01:35:07 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: No)
    Attachment (v16-0001-Overhaul-inheritance-update-delete-planning.patch) at 2019-01-21 09:01:39 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: No)
    Attachment (v15-0001-Overhaul-inheritance-update-delete-planning.patch) at 2019-01-17 02:17:45 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: No)
    Attachment (0001-Some-fixups-for-b60c397599-v2.patch) at 2019-01-16 06:22:26 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (0001-Some-fixups-for-b60c397599-v2.patch) at 2019-01-11 13:00:24 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (b60c397599-fixups-v2.patch) at 2019-01-11 06:24:03 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (b60c397599-fixups.patch) at 2019-01-11 02:07:58 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (v12-0001-Move-inheritance-expansion-code-into-its-own-fil.patch) at 2019-01-10 08:41:21 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (v11-0001-Overhaul-inheritance-update-delete-planning.patch) at 2019-01-08 06:30:10 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: No)
    Attachment (v10-0001-Overhaul-inheritance-update-delete-planning.patch) at 2018-12-27 11:25:38 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: No)
    Attachment (v9-0001-delta.diff) at 2018-12-25 07:47:24 from "Imai, Yoshikazu" <imai.yoshikazu at jp.fujitsu.com> (Patch: Yes)
    Attachment (v9-0001-Overhaul-inheritance-update-delete-planning.patch) at 2018-12-06 08:25:41 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: No)
    Attachment (v8-0001-Overhaul-inheritance-update-delete-planning.patch) at 2018-11-21 10:23:52 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: No)
    Attachment (v7-0001-Overhaul-inheritance-update-delete-planning.patch) at 2018-11-14 11:01:16 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: No)
    Attachment (v6-0001-Overhaul-inheritance-update-delete-planning.patch) at 2018-11-14 10:28:32 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: No)
    Attachment (verify_em_child.diff) at 2018-11-10 11:59:50 from David Rowley <david.rowley at 2ndquadrant.com> (Patch: Yes)
    Attachment (v5-0001-Store-inheritance-root-parent-index-in-otherrel-s.patch) at 2018-11-09 08:55:05 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (0002-delta.patch) at 2018-11-07 01:00:17 from "Imai, Yoshikazu" <imai.yoshikazu at jp.fujitsu.com> (Patch: Yes)
    Attachment (0001-Store-inheritance-root-parent-index-in-otherrel-s-Re.patch) at 2018-10-26 10:37:52 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (v3-0001-Overhaul-inheritance-update-delete-planning.patch) at 2018-09-14 10:28:32 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (v2-0001-Overhaul-partitioned-table-update-delete-planning.patch) at 2018-08-30 09:29:28 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (0001-Overhaul-partitioned-table-update-delete-planning.patch) at 2018-08-29 12:06:16 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)

History

When	Who	What
2019-06-03 07:49:02	keisuke kuroda (keisuke.kuroda.3862)	Removed keisuke.kuroda.3862 from reviewers
2019-06-03 07:49:00	keisuke kuroda (keisuke.kuroda.3862)	Added keisuke.kuroda.3862 as reviewer
2019-04-01 04:23:45	Amit Langote (amitlan)	Closed in commitfest 2019-03 with status: Committed
2019-03-26 21:55:32	Tom Lane (tgl)	Added tgl as committer
2019-03-25 13:58:00	Justin Pryzby (justinpryzby)	New status: Needs review
2019-03-25 08:14:39	David Steele (dsteele)	New status: Waiting on Author
2019-03-21 12:45:51	Jesper Pedersen (jpedersen)	New status: Ready for Committer
2019-02-22 17:48:02	Justin Pryzby (justinpryzby)	Changed targetversion to 12
2019-02-22 17:46:59	Justin Pryzby (justinpryzby)	New status: Needs review
2019-02-20 20:17:55	Tom Lane (tgl)	New status: Waiting on Author
2019-02-20 20:17:50	Tom Lane (tgl)	Removed tgl from committers
2019-02-19 16:05:36	Amit Langote (amitlan)	New status: Needs review
2019-02-18 22:02:18	Tom Lane (tgl)	New status: Waiting on Author
2019-02-18 20:17:45	Tom Lane (tgl)	Added tgl as committer
2019-02-12 07:58:24	Amit Langote (amitlan)	New status: Needs review
2019-02-04 04:02:31	Michael Paquier (michael-kun)	New status: Waiting on Author
2019-02-04 04:02:24	Michael Paquier (michael-kun)	Closed in commitfest 2019-01 with status: Moved to next CF
2019-02-04 04:02:22	Michael Paquier (michael-kun)	New status: Needs review
2019-01-31 03:39:29	David Rowley (davidrowley)	New status: Waiting on Author
2019-01-21 14:47:55	Jesper Pedersen (jpedersen)	New status: Needs review
2019-01-15 05:54:42	David Rowley (davidrowley)	New status: Waiting on Author
2018-11-30 23:18:24	Dmitry Dolgov (erthalion)	Closed in commitfest 2018-11 with status: Moved to next CF
2018-11-07 19:49:51	Jesper Pedersen (jpedersen)	Added jpedersen as reviewer
2018-11-02 06:55:22	Yoshikazu Imai (yimai)	Added yimai as reviewer
2018-10-29 07:55:16	Amit Langote (amitlan)	New status: Needs review
2018-10-02 01:21:05	Michael Paquier (michael-kun)	New status: Waiting on Author
2018-10-02 01:20:59	Michael Paquier (michael-kun)	Closed in commitfest 2018-09 with status: Moved to next CF
2018-10-02 01:20:50	Michael Paquier (michael-kun)	New status: Needs review
2018-09-11 03:50:55	David Rowley (davidrowley)	New status: Waiting on Author
2018-08-31 08:51:16	Dilip Kumar (dilip.kumar)	Added dilip.kumar as reviewer
2018-08-30 01:31:59	David Rowley (davidrowley)	Added davidrowley as reviewer
2018-08-30 01:09:05	Amit Langote (amitlan)	Changed authors to Amit Langote (amitlan)
2018-08-30 01:08:57	Amit Langote (amitlan)	Attached mail thread 9d7c5112-cb99-6a47-d3be-cf1ee6862a1d@lab.ntt.co.jp
2018-08-30 01:08:56	Amit Langote (amitlan)	Created patch record

Edit