Make nbtree keys unique by appending heap TID, suffix truncation
2019-03-25 17:05:12
Peter Geoghegan (pgeoghegan)
Closed in commitfest 2019-03 with status: Committed
2019-03-25 17:05:12
Peter Geoghegan (pgeoghegan)
Changed committer to pgeoghegan
2019-03-18 23:13:52
Peter Eisentraut (petere)
Removed petere from reviewers
2019-03-04 21:20:53
Peter Geoghegan (pgeoghegan)
Added annotation "v14 of the patch, which makes some additional changes to how a split point is chosen based on recent feedback from Heikki" to CAH2-Wz=Dhkbguk31kCgs62Uj6cqsQn3GA3SYBDp-FWidKncwYA@mail.gmail.com
2019-02-26 04:34:39
Peter Geoghegan (pgeoghegan)
Added annotation "v13 of the patch, which takes a "top down" approach to page splits involving materializing all legal splits up front, per suggestion from Heikki" to CAH2-Wzn3g7TyaU7C40heNM9fEaDAezECM0RC3e_MC+8CW7tk4g@mail.gmail.com
2019-02-21 02:22:01
Peter Geoghegan (pgeoghegan)
Removed pgeoghegan from reviewers
2019-02-21 02:21:57
Peter Geoghegan (pgeoghegan)
Added pgeoghegan as reviewer
2019-02-14 20:26:49
Peter Geoghegan (pgeoghegan)
Added annotation "TPC-C style benchmark result that demonstrates the effectiveness of the patch at controlling index bloat, and its positive impact on performance in general" to CAH2-WzmsK-1qVR8xC86DXv8U0cHwfPcuH6hhA740fCeEu3XsVg@mail.gmail.com
2019-02-11 20:58:59
Peter Geoghegan (pgeoghegan)
Added annotation "v12 of the patch, which tweaks the "cache binary search" mechanism used by unique index insertions, and improves test coverage" to CAH2-Wz=yTWnVu+HeHGKb2AGiADL9eprn-cKYAto4MkKOuiGtRQ@mail.gmail.com
2019-02-11 20:56:35
Peter Geoghegan (pgeoghegan)
New status: Needs review
2019-02-07 21:20:19
Peter Geoghegan (pgeoghegan)
New status: Waiting on Author
2019-02-07 21:19:44
Peter Geoghegan (pgeoghegan)
Changed reviewers to Heikki Linnakangas (heikki), Peter Eisentraut (petere), Andrey Lepikhov (lepikhov)
2019-02-07 21:19:44
Peter Geoghegan (pgeoghegan)
Changed targetversion to 12
2019-02-04 05:24:20
Michael Paquier (michael-kun)
Closed in commitfest 2019-01 with status: Moved to next CF
2019-01-24 01:48:27
Peter Geoghegan (pgeoghegan)
Added annotation "v11 of the patch, which entirely avoids buffer locking metapage and system catalog index pages in new and possibly risky ways" to CAH2-Wzmr=kobQx11s7UvqjYVx9Y49GhPpVxL7C8S36ayTUqVWQ@mail.gmail.com
2019-01-09 00:50:41
Peter Geoghegan (pgeoghegan)
New status: Needs review
2019-01-09 00:50:09
Peter Geoghegan (pgeoghegan)
Added annotation "v10 of the patch, which does some minor refactoring requested by Heikki" to CAH2-Wzm_nBWnbO8wG+zvHHF2QA9j=BOByXZcmhPK1PBii859Kg@mail.gmail.com
2019-01-04 09:41:41
Peter Eisentraut (petere)
New status: Waiting on Author
2018-12-04 03:15:34
Peter Geoghegan (pgeoghegan)
Added annotation "v9 of the patch, which fixes the Windows build" to CAH2-Wz=apbKyaFhEfRN3UK_yXZ8DSE4Ybr0A3D87=4JWyy1QPA@mail.gmail.com
2018-12-01 12:09:47
Dmitry Dolgov (erthalion)
Closed in commitfest 2018-11 with status: Moved to next CF
2018-11-24 23:17:33
Peter Geoghegan (pgeoghegan)
Added annotation "v8 of the patch, which properly addresses pg_depend-related test instability" to CAH2-WznXpL_1ybkNNj-29V6Jrd_p0KBpj2AN=xahBDiNaU1Kfg@mail.gmail.com
2018-11-13 01:50:01
Peter Geoghegan (pgeoghegan)
Added annotation "v7 of the patch, which adds pg_upgrade support, and sorts heap TIDs in ASC order" to CAH2-WzkOmUduME31QnuTFpimejuQoiZ-HOf0pOWeFZNhTMctvA@mail.gmail.com
2018-11-02 09:03:06
Andrei Lepikhov (lepikhov)
Added lepikhov as reviewer
2018-10-03 23:52:00
Peter Geoghegan (pgeoghegan)
Added annotation "v6 of the patch, which greatly helps with TPC-C index bloat, and fixes a significant regression against master with unique indexes" to CAH2-WzkpKeZJrXvR_p7VSY1b-s85E3gHyTbZQzR0BkJ5LrWF_A@mail.gmail.com
2018-10-02 04:40:13
Michael Paquier (michael-kun)
Closed in commitfest 2018-09 with status: Moved to next CF
2018-09-20 23:23:25
Peter Geoghegan (pgeoghegan)
Attached mail thread CAH2-WzmjgBz-RL2-nyPc+NRZnU73YSLGEwZRyB2DhUQEdkEujg@mail.gmail.com
2018-09-19 18:29:37
Peter Geoghegan (pgeoghegan)
Added annotation "v5 of the patch, which greatly simplifies the logic to make picking a split point care about the needs of suffix truncation" to CAH2-WzkfK=JVHjkd17TLDvsFb6psduTt5WYiT8dg+-UFc+rSSQ@mail.gmail.com
2018-09-12 18:12:55
Peter Geoghegan (pgeoghegan)
Added annotation "v4 of the patch, which has the logic for picking a split point consider suffix truncation specifically" to CAH2-WzmmoLNQOj9mAD78iQHfWLJDszHEDrAzGTUMG3mVh5xWPw@mail.gmail.com
2018-09-07 10:08:12
Peter Eisentraut (petere)
Added petere as reviewer
2018-09-02 23:31:06
Peter Geoghegan (pgeoghegan)
Added annotation "Motivating example. Master branch churn with many duplicates fails to recycle space. Patch is shown to fix the problem, leaving much smaller index." to CAH2-Wzmf0fvVhU+SSZpGW4Qe9t--j_DmXdX3it5JcdB8FF2EsA@mail.gmail.com
2018-09-02 23:27:01
Peter Geoghegan (pgeoghegan)
Attached mail thread CAH2-Wzmf0fvVhU+SSZpGW4Qe9t--j_DmXdX3it5JcdB8FF2EsA@mail.gmail.com
2018-08-31 16:29:57
Peter Geoghegan (pgeoghegan)
Added annotation "v3 of patch, plus benchmark information" to CAH2-WzkmTRXh=zyMAUHyG3=O-QQip6CJc2VyNijRO-vzgPxmoQ@mail.gmail.com
2018-08-31 16:28:08
Peter Geoghegan (pgeoghegan)
Changed authors to Peter Geoghegan (pgeoghegan)
2018-08-31 16:27:31
Peter Geoghegan (pgeoghegan)
Attached mail thread CAH2-WzkVb0Kom=R+88fDFb=JSxZMFvbHVC6Mn9LJ2n=X=kS-Uw@mail.gmail.com
2018-08-31 16:27:31
Peter Geoghegan (pgeoghegan)
Created patch record