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, 8 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