Reduce partition tuple routing overheads

Edit
ID 1690
Title Reduce partition tuple routing overheads
Topic Performance
Created 2018-06-22 22:16:33
Last modified 2018-11-16 18:26:25 (5 years, 10 months ago)
Latest email 2018-11-23 00:16:46 (5 years, 10 months ago)
Status
2018-11: Committed
2018-09: Moved to next CF
2018-07: Moved to next CF
Target version
Authors David Rowley (davidrowley)
Reviewers Amit Langote (amitlan), Jesper Pedersen (jpedersen)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/1690
git checkout commitfest/cf/1690
Emails
Speeding up INSERTs and UPDATEs to partitioned tables
First at 2018-06-22 06:28:08 by David Rowley <david.rowley at 2ndquadrant.com>
Latest at 2018-11-23 00:16:46 by David Rowley <david.rowley at 2ndquadrant.com>
Latest attachment (ExecFindPartition-typo.patch) at 2018-11-22 02:32:04 from Amit Langote <amitlangote09 at gmail.com>
    Attachment (ExecFindPartition-typo.patch) at 2018-11-22 02:32:04 from Amit Langote <amitlangote09 at gmail.com> (Patch: Yes)
    Attachment (v19-Speed-up-INSERT-and-UPDATE-on-partitioned-tables.patch) at 2018-11-16 15:14:06 from Alvaro Herrera <alvherre at 2ndquadrant.com> (Patch: Yes)
    Attachment (v18-delta.patch) at 2018-11-16 02:39:56 from Alvaro Herrera <alvherre at 2ndquadrant.com> (Patch: Yes)
    Attachment (v17-0001-Speed-up-INSERT-and-UPDATE-on-partitioned-tables.patch) at 2018-11-14 04:16:02 from David Rowley <david.rowley at 2ndquadrant.com> (Patch: Yes)
    Attachment (v16-0001-Speed-up-INSERT-and-UPDATE-on-partitioned-tables.patch) at 2018-11-12 23:17:39 from David Rowley <david.rowley at 2ndquadrant.com> (Patch: Yes)
    Attachment (v14-0002-Unsafe-locking-reduction-for-partitioned-INSERT-.patch) at 2018-11-08 22:26:05 from David Rowley <david.rowley at 2ndquadrant.com> (Patch: Yes)
    Attachment (v14_v15.diff) at 2018-11-08 11:28:09 from David Rowley <david.rowley at 2ndquadrant.com> (Patch: Yes)
    Attachment (v14-0001-Speed-up-INSERT-and-UPDATE-on-partitioned-tables.patch) at 2018-11-07 11:46:54 from David Rowley <david.rowley at 2ndquadrant.com> (Patch: Yes)
    Attachment (v13-0001-Speed-up-INSERT-and-UPDATE-on-partitioned-tables.patch) at 2018-11-04 10:07:09 from David Rowley <david.rowley at 2ndquadrant.com> (Patch: Yes)
    Attachment (1-revise-ExecFindPartition-interface.patch) at 2018-11-01 09:39:34 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (v12-0001-Speed-up-INSERT-and-UPDATE-on-partitioned-tables.patch) at 2018-11-01 01:30:55 from David Rowley <david.rowley at 2ndquadrant.com> (Patch: Yes)
    Attachment (v11-0001-Speed-up-INSERT-and-UPDATE-on-partitioned-tables.patch) at 2018-10-31 23:58:05 from David Rowley <david.rowley at 2ndquadrant.com> (Patch: Yes)
    Attachment (v10-0001-Speed-up-INSERT-and-UPDATE-on-partitioned-tables.patch) at 2018-10-05 12:55:34 from David Rowley <david.rowley at 2ndquadrant.com> (Patch: Yes)
    Attachment (v9-0001-Speed-up-INSERT-and-UPDATE-on-partitioned-tables.patch) at 2018-09-17 09:15:14 from David Rowley <david.rowley at 2ndquadrant.com> (Patch: Yes)
    Attachment (v8-0001-Speed-up-INSERT-and-UPDATE-on-partitioned-tables.patch) at 2018-08-22 12:30:14 from David Rowley <david.rowley at 2ndquadrant.com> (Patch: Yes)
    Attachment (v7-0001-Speed-up-INSERT-and-UPDATE-on-partitioned-tables.patch) at 2018-08-22 07:08:46 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (v3_Refactor-handling-of-child_parent_tupconv_maps.patch) at 2018-08-21 05:44:36 from David Rowley <david.rowley at 2ndquadrant.com> (Patch: Yes)
    Attachment (v2-0002-Refactor-handling-of-child_parent_tupconv_maps.patch) at 2018-08-03 05:58:03 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (v5-0001-Speed-up-INSERT-and-UPDATE-on-partitioned-tables.patch) at 2018-08-02 03:47:13 from David Rowley <david.rowley at 2ndquadrant.com> (Patch: Yes)
    Attachment (v4-0001-Speed-up-INSERT-and-UPDATE-on-partitioned-tables.patch) at 2018-07-31 07:03:32 from David Rowley <david.rowley at 2ndquadrant.com> (Patch: Yes)
    Attachment (0002-Some-refactoring-around-child_parent_tupconv_maps.patch) at 2018-07-30 08:26:52 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (v2-delta2.patch) at 2018-07-28 01:54:43 from David Rowley <david.rowley at 2ndquadrant.com> (Patch: Yes)
    Attachment (v2-delta.patch) at 2018-07-27 07:11:11 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (v2-0001-Speed-up-INSERT-and-UPDATE-on-partitioned-tables.patch) at 2018-07-26 16:19:34 from David Rowley <david.rowley at 2ndquadrant.com> (Patch: Yes)
    Attachment (david-0001-delta-v2.patch) at 2018-07-18 08:29:19 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (david-0001-delta.patch) at 2018-07-13 08:20:47 from Amit Langote <Langote_Amit_f8 at lab.ntt.co.jp> (Patch: Yes)
    Attachment (v1-0001-Speed-up-INSERT-and-UPDATE-on-partitioned-tables.patch) at 2018-06-22 06:28:08 from David Rowley <david.rowley at 2ndquadrant.com> (Patch: Yes)
History
When Who What
2018-11-16 18:26:25 Álvaro Herrera (alvherre) Closed in commitfest 2018-11 with status: Committed
2018-11-14 04:30:49 Amit Langote (amitlan) New status: Ready for Committer
2018-11-08 00:28:33 Amit Langote (amitlan) New status: Needs review
2018-11-05 18:02:30 Álvaro Herrera (alvherre) Added alvherre as committer
2018-10-02 01:30:20 Michael Paquier (michael-kun) Closed in commitfest 2018-09 with status: Moved to next CF
2018-08-23 00:55:59 Amit Langote (amitlan) New status: Ready for Committer
2018-08-10 22:19:38 Andrew Dunstan (adunstan) Closed in commitfest 2018-07 with status: Moved to next CF
2018-07-03 13:21:22 Jesper Pedersen (jpedersen) Added jpedersen as reviewer
2018-07-03 03:27:32 Amit Langote (amitlan) Added amitlan as reviewer
2018-06-22 22:16:43 David Rowley (davidrowley) Changed authors to David Rowley (davidrowley)
2018-06-22 22:16:33 David Rowley (davidrowley) Attached mail thread CAKJS1f_1RJyFquuCKRFHTdcXqoPX-PYqAd7nz=GVBwvGh4a6xA@mail.gmail.com
2018-06-22 22:16:33 David Rowley (davidrowley) Created patch record
Edit