Speed up planning with partitions

Edit
Title Speed up planning with partitions
Topic Performance
Created 2018-08-30 01:08:56
Last modified 2019-04-01 04:23:45 (2 months, 2 weeks ago)
Latest email 2019-04-05 10:47:47 (2 months, 1 week 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 12
Authors Amit Langote (amitlan)
Reviewers dilip kumar (dilip.kumar), Jesper Pedersen (jpedersen), Yoshikazu Imai (yimai), David Rowley (davidrowley)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