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 (6 years ago)

Latest email 2018-11-23 00:16:46 (5 years, 11 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