ID | 690 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Title | Parallel tuplesort (for parallel B-Tree index creation) | ||||||||||||||||||||||||||||||||||||||||||||||||||||
Topic | Performance | ||||||||||||||||||||||||||||||||||||||||||||||||||||
Created | 2016-08-01 22:19:22 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
Last modified | 2018-02-03 04:29:57 (6 years, 8 months ago) | ||||||||||||||||||||||||||||||||||||||||||||||||||||
Latest email | 2018-02-08 12:45:52 (6 years, 7 months ago) | ||||||||||||||||||||||||||||||||||||||||||||||||||||
Status |
2018-01: Committed
2017-03: Moved to next CF
2017-01: Moved to next CF
2016-11: Moved to next CF
2016-09: Moved to next CF
|
||||||||||||||||||||||||||||||||||||||||||||||||||||
Target version | |||||||||||||||||||||||||||||||||||||||||||||||||||||
Authors | Peter Geoghegan (pgeoghegan), Rushabh Lathia (rlathia) | ||||||||||||||||||||||||||||||||||||||||||||||||||||
Reviewers | Thomas Munro (macdice)Become reviewer | ||||||||||||||||||||||||||||||||||||||||||||||||||||
Committer | Robert Haas (rhaas) | ||||||||||||||||||||||||||||||||||||||||||||||||||||
Links | CFbot results (CirrusCI) CFbot GitHub Wiki | ||||||||||||||||||||||||||||||||||||||||||||||||||||
Checkout latest CFbot patchset |
Go to your local checkout of the PostgreSQL repository and run:
|
||||||||||||||||||||||||||||||||||||||||||||||||||||
Emails |
|
When | Who | Annotation | |
---|---|---|---|
2016-08-08 20:54:30 | Peter Geoghegan (pgeoghegan) | From Peter Geoghegan <pg@heroku.com> at 2016-08-08 19:44:02 |
Related design discussion -- how tuplesort.c may in the future support partitioning |
When | Who | What |
---|---|---|
2018-02-03 04:29:57 | Peter Geoghegan (pgeoghegan) | Closed in commitfest 2018-01 with status: Committed |
2018-02-03 04:29:57 | Peter Geoghegan (pgeoghegan) | Changed committer to rhaas |
2018-01-10 03:13:06 | Peter Geoghegan (pgeoghegan) | New status: Ready for Committer |
2018-01-06 00:16:32 | Peter Geoghegan (pgeoghegan) | Added annotation "Revision of Rushabh's most recent patch -- mostly just polishing." to CAH2-Wzk66gCxRjs8tQWQwBc8kg1VG9+KNitutjg3K=jsYL+euA@mail.gmail.com |
2017-11-14 22:56:18 | Peter Geoghegan (pgeoghegan) | Changed authors to Peter Geoghegan (pgeoghegan), Rushabh Lathia (rlathia) |
2017-11-14 22:55:27 | Peter Geoghegan (pgeoghegan) | Added annotation "v13 -- Contains fixes requested by Peter following adopting patch to parallel hash join BufFile infrastructure" to CAGPqQf17vxDXFi=u9yf=aDF_0LJ+NGmRKJ0fUJYVUtzseQm6Zw@mail.gmail.com |
2017-11-14 22:51:38 | Peter Geoghegan (pgeoghegan) | Closed in commitfest 2017-03 with status: Moved to next CF |
2017-11-14 22:51:32 | Peter Geoghegan (pgeoghegan) | New status: Needs review |
2017-03-23 02:32:23 | Peter Geoghegan (pgeoghegan) | Closed in commitfest 2017-03 with status: Returned with feedback |
2017-03-20 01:06:55 | Peter Geoghegan (pgeoghegan) | Added annotation "V10 -- Fixes bug caused by commit 2609e91fc, bitrot" to CAH2-WznqgFJVb0OpbrS445TnyS8ib8kSxAASvLqLCaSnQeyd0Q@mail.gmail.com |
2017-03-12 22:11:30 | Peter Geoghegan (pgeoghegan) | Added annotation "V9 -- Bulletproof resource management, significantly simplified cost model" to CAH2-Wznuf2nwsr6=4n8aRQtqCu3PaFYuvDEoYeEenYK-bXYX4w@mail.gmail.com |
2017-03-12 22:06:03 | Peter Geoghegan (pgeoghegan) | New status: Needs review |
2017-02-28 19:32:44 | Peter Geoghegan (pgeoghegan) | Attached mail thread CAH2-WzmjVMCUviDnUmrJnvhfPpzODtCM71NEHx7_QYCtz+=8ng@mail.gmail.com |
2017-02-27 22:35:14 | Peter Geoghegan (pgeoghegan) | New status: Waiting on Author |
2017-02-10 00:12:17 | Peter Geoghegan (pgeoghegan) | Added annotation "V8 -- rebased on top of logtape.c bugfix, implements BufFile refcount mechanism" to CAH2-WzmWtorLU0qi63dTgNbBJPds1wRLDtoZSDRwkRWdvBnMww@mail.gmail.com |
2017-02-01 04:38:04 | Michael Paquier (michael-kun) | Closed in commitfest 2017-01 with status: Moved to next CF |
2017-01-03 23:57:44 | Peter Geoghegan (pgeoghegan) | Added annotation "V7 -- rebased on top of logtape.c simplifications, pg_restore avoids using parallel CREATE INDEX unless storage parameter was used, refactoring" to CAM3SWZRkQ64nhFiWeGTx4CUuvCaL8m+GSg8PhssHY=E-_wNpBA@mail.gmail.com |
2016-12-07 00:25:00 | Thomas Munro (macdice) | Added macdice as reviewer |
2016-12-05 04:26:29 | Haribabu Kommi (haribabu) | Closed in commitfest 2016-11 with status: Moved to next CF |
2016-12-04 01:30:15 | Peter Geoghegan (pgeoghegan) | Added annotation "V6 -- tuplesort.c now uses condition variables" to CAM3SWZQ0EgCxs2NoEUwB6BACi-pp5qVmp432i+Wh_XyUrg1FbQ@mail.gmail.com |
2016-11-08 05:52:54 | Peter Geoghegan (pgeoghegan) | Deleted annotation ""shift down" merge heap patch committed" from 19f05353-9514-9139-619a-dbaa7a0e5e78@iki.fi |
2016-11-08 05:52:37 | Peter Geoghegan (pgeoghegan) | Deleted annotation "This is a spin-off of the parallel CREATE INDEX stuff, intended to represent 3 patches that are helpful with merging. Merge performance is particularly important for parallel tuplesort, but is independently useful." from CAM3SWZRhBhiknTF_=NjDSnNZ11hx=U_SEYwbc5vd=x7M4mMiCw@mail.gmail.com |
2016-11-08 05:52:12 | Peter Geoghegan (pgeoghegan) | Deleted annotation "Patch has bitrot. New version pending." from CAM3SWZTjULhhHPMYb9KYKD48rs_RgnMQPMZMdf0dqkRpZoY_ZA@mail.gmail.com |
2016-11-08 04:35:03 | Peter Geoghegan (pgeoghegan) | Added annotation "V5 -- Overhaul to cost model, new testing tool" to CAM3SWZSA_+CBsaYyb22cdqwkfNgD9vQL74NVYnbu62ZqhLD4Og@mail.gmail.com |
2016-10-27 20:21:59 | Peter Geoghegan (pgeoghegan) | Changed wikilink to https://wiki.postgresql.org/wiki/Parallel_External_Sort |
2016-10-26 20:16:04 | Peter Geoghegan (pgeoghegan) | Detached mail thread f298f77a-cf06-e70c-d5a4-a20b472b4627@iki.fi |
2016-10-26 16:42:26 | Peter Geoghegan (pgeoghegan) | Added annotation "Do-over of original benchmark from August 1, showing how preloading work from Heikki (and other improvements) have increased scalability of parallel CREATE INDEX" to CAM3SWZSsvig8eZtxCG1L9bZZw+-uWdJ48yxSM41QmNLtJeQSyA@mail.gmail.com |
2016-10-25 02:06:25 | Peter Geoghegan (pgeoghegan) | Added annotation "V4 -- mechanical rebase on top of refactoring commit b75f467b6eec0678452fd8d7f8d306e6df3a1076" to CAM3SWZStcX5DNxRvjGTj4KRvjg+sV2CdxJvL9S4cksbRumVmhA@mail.gmail.com |
2016-10-08 00:49:11 | Peter Geoghegan (pgeoghegan) | Added annotation "V3 -- rebased on top of Heikki's logtape.c preload memory patch" to CAM3SWZTmkOFEiCDpUNaO4n9-1xcmWP-1NXmT7h0Pu3gM2YuHvg@mail.gmail.com |
2016-10-03 03:37:07 | Michael Paquier (michael-kun) | Closed in commitfest 2016-09 with status: Moved to next CF |
2016-09-12 04:17:42 | Peter Geoghegan (pgeoghegan) | Added annotation ""shift down" merge heap patch committed" to 19f05353-9514-9139-619a-dbaa7a0e5e78@iki.fi |
2016-09-12 04:10:02 | Peter Geoghegan (pgeoghegan) | Added annotation "Review" to CAM3SWZQrU12mog=TG9jvNOpeUL5Krk9N1Y8GmsLGTGRBJui-aQ@mail.gmail.com |
2016-09-12 04:09:30 | Peter Geoghegan (pgeoghegan) | Added annotation "Latest version from Heikki -- applies on top master branch on 2016-09-11 (with Peter's 0003-* merge heap patch committed)" to 49817174-c2b6-1378-3d3e-285d270f8fcc@iki.fi |
2016-09-12 04:07:11 | Peter Geoghegan (pgeoghegan) | Added annotation "Heikki's proposed alternative to patch 0002-* from original patch set (batch memory patch)" to f298f77a-cf06-e70c-d5a4-a20b472b4627@iki.fi |
2016-09-12 04:01:13 | Peter Geoghegan (pgeoghegan) | Attached mail thread f298f77a-cf06-e70c-d5a4-a20b472b4627@iki.fi |
2016-09-11 18:07:19 | Peter Geoghegan (pgeoghegan) | Added annotation "V2 -- uses maintenance_work_mem as budget for entire CREATE INDEX, regardless of number of workers" to CAM3SWZTW+3vmZugxhy=_jdm5YxNXGdAEHv5Sz6jBpdyfsJVkRg@mail.gmail.com |
2016-08-22 21:50:52 | Peter Geoghegan (pgeoghegan) | Added annotation "Patch has bitrot. New version pending." to CAM3SWZTjULhhHPMYb9KYKD48rs_RgnMQPMZMdf0dqkRpZoY_ZA@mail.gmail.com |
2016-08-16 00:47:06 | Peter Geoghegan (pgeoghegan) | Added annotation "This is a spin-off of the parallel CREATE INDEX stuff, intended to represent 3 patches that are helpful with merging. Merge performance is particularly important for parallel tuplesort, but is independently useful." to CAM3SWZRhBhiknTF_=NjDSnNZ11hx=U_SEYwbc5vd=x7M4mMiCw@mail.gmail.com |
2016-08-08 20:54:30 | Peter Geoghegan (pgeoghegan) | Added annotation "Related design discussion -- how tuplesort.c may in the future support partitioning" to CAM3SWZR+ATYAzyMT+hm-Bo=1L1smtJbNDtibwBTKtYqS0dYZVg@mail.gmail.com |
2016-08-08 20:53:40 | Peter Geoghegan (pgeoghegan) | Attached mail thread CAM3SWZR+ATYAzyMT+hm-Bo=1L1smtJbNDtibwBTKtYqS0dYZVg@mail.gmail.com |
2016-08-01 22:19:31 | Peter Geoghegan (pgeoghegan) | Changed authors to Peter Geoghegan (pgeoghegan) |
2016-08-01 22:19:22 | Peter Geoghegan (pgeoghegan) | Attached mail thread CAM3SWZQKM=Pzc=CAHzRixKjp2eO5Q0Jg1SoFQqeXFQ647JiwqQ@mail.gmail.com |
2016-08-01 22:19:22 | Peter Geoghegan (pgeoghegan) | Created patch record |