Gather speed-up

Edit

Title

Gather speed-up

Topic

Performance

Created

2017-05-29 04:13:59

Last modified

2018-03-02 17:21:56 (6 years, 1 month ago)

Latest email

2018-03-29 16:18:43 (6 years 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

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