Gather speed-up

Edit
ID 1156
Title Gather speed-up
CI (CFBot) Not processed
Stats (from CFBot) Unknown
Topic Performance
Tags
Created 2017-05-29 04:13:59
Last modified 2018-03-02 17:21:56 (7 years ago)
Latest email 2018-03-29 16:18:43 (7 years ago)
Status
2018-03 (2018-03-01 – 2018-03-31): Committed
2018-01 (2018-01-01 – 2018-01-31): Moved to different CF
2017-11 (2017-11-01 – 2017-11-30): Moved to different CF
2017-09 (2017-09-01 – 2017-09-30): Moved to different 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