Enhance performance for non-bulk inserts into partitioned tables

Edit

ID 1415

Title Enhance performance for non-bulk inserts into partitioned tables

Topic Performance

Created 2017-12-19 10:08:36

Last modified 2018-02-23 07:48:11 (6 years, 8 months ago)

Latest email 2018-03-05 04:21:51 (6 years, 8 months ago)

Status

2018-03: Committed

2018-01: Moved to next CF

Target version

Authors Amit Langote (amitlan)

Reviewers Etsuro Fujita (efujita)Become reviewer

Committer Robert Haas (rhaas)

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/1415
git checkout commitfest/cf/1415

Emails

non-bulk inserts and tuple routing: First at 2017-12-19 10:06:16 by Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp>
Latest at 2018-03-05 04:21:51 by Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp>
Latest attachment (partition-WCO-qual-parent-fix.patch) at 2018-03-05 02:21:46 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp>
    Attachment (partition-WCO-qual-parent-fix.patch) at 2018-03-05 02:21:46 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (comments.patch) at 2018-02-22 16:53:15 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (v11-0001-During-tuple-routing-initialize-per-partition-ob-efujita.patch) at 2018-02-20 10:40:49 from Etsuro Fujita <fujita.etsuro at lab.ntt.co.jp> (Patch: Yes)
    Attachment (v11-0001-During-tuple-routing-initialize-per-partition-ob.patch) at 2018-02-19 04:19:10 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (v10-0001-During-tuple-routing-initialize-per-partition-ob-efujita.patch) at 2018-02-16 10:50:38 from Etsuro Fujita <fujita.etsuro at lab.ntt.co.jp> (Patch: Yes)
    Attachment (v10-0001-During-tuple-routing-initialize-per-partition-ob.patch) at 2018-02-16 09:23:55 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (v9-0001-During-tuple-routing-initialize-per-partition-obj.patch) at 2018-02-16 04:42:12 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (v8-0001-During-tuple-routing-initialize-per-partition-obj.patch) at 2018-02-16 01:49:12 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (v7-0001-During-tuple-routing-initialize-per-partition-obj.patch) at 2018-02-13 01:12:40 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (v6-0001-During-tuple-routing-initialize-per-partition-obj.patch) at 2018-02-09 05:32:12 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (v24-0001-Refactor-partition-tuple-conversion-maps-handlin.patch) at 2018-02-05 05:34:25 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (v4-0001-Teach-CopyFrom-to-use-ModifyTableState-for-tuple-.patch) at 2018-01-25 02:11:57 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (v3-0001-Teach-CopyFrom-to-use-ModifyTableState-for-tuple-.patch) at 2018-01-24 08:25:08 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (v2-0001-Teach-CopyFrom-to-use-ModifyTableState-for-tuple-.patch) at 2018-01-19 08:56:03 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (0001-Teach-CopyFrom-to-use-ModifyTableState-for-tuple-rou.patch) at 2017-12-19 10:06:16 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)

History

When	Who	What
2018-02-23 07:48:11	Amit Langote (amitlan)	Closed in commitfest 2018-03 with status: Committed
2018-02-23 07:48:11	Amit Langote (amitlan)	Changed committer to rhaas
2018-02-16 10:53:23	Etsuro Fujita (efujita)	New status: Ready for Committer
2018-02-15 09:41:27	Amit Langote (amitlan)	New status: Needs review
2018-02-08 10:23:10	Etsuro Fujita (efujita)	New status: Waiting on Author
2018-02-06 01:28:22	Amit Langote (amitlan)	Closed in commitfest 2018-01 with status: Moved to next CF
2018-01-23 11:16:54	Etsuro Fujita (efujita)	Added efujita as reviewer
2017-12-19 10:08:48	Amit Langote (amitlan)	Changed authors to Amit Langote (amitlan)
2017-12-19 10:08:37	Amit Langote (amitlan)	Attached mail thread 8975331d-d961-cbdd-f862-fdd3d97dc2d0@lab.ntt.co.jp
2017-12-19 10:08:36	Amit Langote (amitlan)	Created patch record

Edit