Gather speed-up

Edit

ID 1156

Title Gather speed-up

Topic Performance

Created 2017-05-29 04:13:59

Last modified 2018-03-02 17:21:56 (6 years, 9 months ago)

Latest email 2018-03-29 16:18:43 (6 years, 8 months ago)

Status

2018-03: Committed

2018-01: Moved to next CF

2017-11: Moved to next CF

2017-09: Moved to next CF

Target version

Authors Rafia Sabih (rafia.sabih)

Reviewers Dilip Kumar (dilip.kumar)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/1156
git checkout commitfest/cf/1156

Emails

[POC] Faster processing at Gather node: First at 2017-05-19 11:55:38 by Rafia Sabih <rafia.sabih at enterprisedb.com>
Latest at 2018-03-29 16:18:43 by Bruce Momjian <bruce at momjian.us>
Latest attachment (shm.diff) at 2018-03-29 16:18:43 from Bruce Momjian <bruce at momjian.us>
    Attachment (shm.diff) at 2018-03-29 16:18:43 from Bruce Momjian <bruce at momjian.us> (Patch: Yes)
    Attachment (0002-shm-mq-reduce-receiver-latch-set-v3.patch) at 2018-02-28 15:06:27 from Robert Haas <robertmhaas at gmail.com> (Patch: Yes)
    Attachment (0001-shm-mq-less-spinlocks-v3.patch) at 2018-01-25 17:09:23 from Robert Haas <robertmhaas at gmail.com> (Patch: Yes)
    Attachment (ml_test_query.sql) at 2017-12-05 13:02:52 from Rafia Sabih <rafia.sabih at enterprisedb.com> (Patch: No)
    Attachment (0001-shm-mq-less-spinlocks-v2.patch) at 2017-12-04 15:50:53 from Robert Haas <robertmhaas at gmail.com> (Patch: Yes)
    Attachment (release_memory_at_gather_merge_shutdown_v1.patch) at 2017-11-26 08:15:32 from Amit Kapila <amit.kapila16 at gmail.com> (Patch: Yes)
    Attachment (plp_patch.txt) at 2017-11-23 10:12:54 from Rafia Sabih <rafia.sabih at enterprisedb.com> (Patch: No)
    Attachment (0001-pass-eflags-to-worker-v2.patch) at 2017-11-18 13:53:43 from Amit Kapila <amit.kapila16 at gmail.com> (Patch: Yes)
    Attachment (gather_analysis_all.zip) at 2017-11-16 12:05:22 from Rafia Sabih <rafia.sabih at enterprisedb.com> (Patch: No)
    Attachment (gather_speedup_test.zip) at 2017-11-14 12:31:47 from Rafia Sabih <rafia.sabih at enterprisedb.com> (Patch: No)
    Attachment (0001-pass-eflags-to-worker-v1.patch) at 2017-11-10 15:09:37 from Robert Haas <robertmhaas at gmail.com> (Patch: Yes)
    Attachment (skip-gather-project-v1.patch) at 2017-11-05 00:05:59 from Robert Haas <robertmhaas at gmail.com> (Patch: Yes)
    Attachment (shm-mq-less-spinlocks-v1.2.patch) at 2017-11-04 11:08:31 from Robert Haas <robertmhaas at gmail.com> (Patch: Yes)
    Attachment (large_tbl_gen.sql) at 2017-10-17 05:01:32 from Rafia Sabih <rafia.sabih at enterprisedb.com> (Patch: No)
    Attachment (faster_gather.patch) at 2017-05-19 11:55:38 from Rafia Sabih <rafia.sabih at enterprisedb.com> (Patch: Yes)
Effect of changing the value for PARALLEL_TUPLE_QUEUE_SIZE: First at 2017-05-30 09:28:04 by Rafia Sabih <rafia.sabih at enterprisedb.com>
Latest at 2017-09-25 09:13:00 by Rafia Sabih <rafia.sabih at enterprisedb.com>
Latest attachment (faster_gather_v3.patch) at 2017-09-25 09:13:00 from Rafia Sabih <rafia.sabih at enterprisedb.com>
    Attachment (faster_gather_v3.patch) at 2017-09-25 09:13:00 from Rafia Sabih <rafia.sabih at enterprisedb.com> (Patch: Yes)
    Attachment (faster_gather_v2.patch) at 2017-09-21 11:20:44 from Rafia Sabih <rafia.sabih at enterprisedb.com> (Patch: Yes)
    Attachment (faster_gather_v1.patch) at 2017-09-06 10:44:45 from Rafia Sabih <rafia.sabih at enterprisedb.com> (Patch: Yes)
    Attachment (q12_ptqs.txt) at 2017-05-30 09:28:04 from Rafia Sabih <rafia.sabih at enterprisedb.com> (Patch: No)

History

When	Who	What
2018-03-02 17:21:56	Robert Haas (rhaas)	Closed in commitfest 2018-03 with status: Committed
2018-03-02 17:17:50	Robert Haas (rhaas)	Added rhaas as committer
2018-03-01 19:49:35	Andres Freund (andresfreund)	New status: Ready for Committer
2018-02-07 15:42:41	David Steele (dsteele)	Closed in commitfest 2018-01 with status: Moved to next CF
2017-11-30 02:03:58	Michael Paquier (michael-kun)	Closed in commitfest 2017-11 with status: Moved to next CF
2017-10-02 12:10:53	Daniel Gustafsson (d_gustafsson)	Closed in commitfest 2017-09 with status: Moved to next CF
2017-09-19 12:31:41	Dilip Kumar (dilip.kumar)	Added dilip.kumar as reviewer
2017-09-13 09:10:34	Aleksander Alekseev (a.alekseev)	New status: Needs review
2017-09-12 14:29:15	Aleksander Alekseev (a.alekseev)	New status: Waiting on Author
2017-09-11 06:59:00	Rafia Sabih (rafia.sabih)	Attached mail thread CAOGQiiOAhNPB7Ow8E4r3dAcLB8LEy_t_oznGeB8B2yQbsj7BFA@mail.gmail.com
2017-08-18 09:44:33	Rafia Sabih (rafia.sabih)	Changed name to Gather speed-up
2017-05-29 04:14:17	Rafia Sabih (rafia.sabih)	Changed authors to Rafia Sabih (rafia.sabih)
2017-05-29 04:13:59	Rafia Sabih (rafia.sabih)	Attached mail thread CAOGQiiMwhOd5-iKZnizn+EdzZmB0bc3xa6rKXQgvhbnQ29zCJg@mail.gmail.com
2017-05-29 04:13:59	Rafia Sabih (rafia.sabih)	Created patch record

Edit