Speed up planning with partitions

Edit

Title

Topic

Performance

Created

2018-08-30 01:08:56

Last modified

2019-02-22 17:48:02 (15 hours, 58 minutes ago)

Latest email

2019-02-22 18:01:46 (15 hours, 45 minutes ago)

Status

2019-03: Needs review

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

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

Committer

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-02-22 18:01:46 by Justin Pryzby <pryzby at telsasoft.com>
Latest 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>
    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: Pending check)
    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-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