Bottom-up index deletion (targets old duplicate versions from non-HOT updates)

Edit
Title Bottom-up index deletion (targets old duplicate versions from non-HOT updates)
Topic Performance
Created 2020-10-08 22:41:04
Last modified 2021-01-13 20:46:52 (9 months, 1 week ago)
Latest email 2021-01-26 18:40:31 (8 months, 4 weeks ago)
Status
2021-01: Committed
2020-11: Moved to next CF
Target version 14
Authors Peter Geoghegan (pgeoghegan)
Reviewers Become reviewer
Committer Peter Geoghegan (pgeoghegan)
Links
Emails
Deleting older versions in unique indexes to avoid page splits
First at 2020-07-01 00:03:25 by Peter Geoghegan <pg at bowt.ie>
Latest at 2021-01-26 18:40:31 by Peter Geoghegan <pg at bowt.ie>
Latest attachment (0006-Experiment-One-array-again.patch) at 2021-01-12 05:26:45 from Peter Geoghegan <pg at bowt.ie>
    Attachment (0006-Experiment-One-array-again.patch) at 2021-01-12 05:26:45 from Peter Geoghegan <pg at bowt.ie> (Patch: Yes)
    Attachment (20210111-v13-regression.diffs) at 2021-01-11 20:19:25 from Victor Yegorov <vyegorov at gmail.com> (Patch: Yes)
    Attachment (v13-0001-Pass-down-logically-unchanged-index-hint.patch) at 2021-01-11 00:06:54 from Peter Geoghegan <pg at bowt.ie> (Patch: Yes)
    Attachment (20210103-pg_bench-alterations.txt) at 2021-01-04 22:07:13 from Victor Yegorov <vyegorov at gmail.com> (Patch: No)
    Attachment (v12-0002-Add-bottom-up-index-deletion.patch) at 2020-12-31 02:54:45 from Peter Geoghegan <pg at bowt.ie> (Patch: No)
    Attachment (delete_stats_regression_tests.txt.gz) at 2020-12-19 23:59:59 from Peter Geoghegan <pg at bowt.ie> (Patch: No)
    Attachment (v11-0001-Pass-down-logically-unchanged-index-hint.patch) at 2020-12-10 01:12:40 from Peter Geoghegan <pg at bowt.ie> (Patch: Yes)
    Attachment (v10-0001-Teach-heapam-to-support-bottom-up-index-deletion.patch) at 2020-11-30 19:50:58 from Peter Geoghegan <pg at bowt.ie> (Patch: Yes)
    Attachment (v9-0001-Make-tableam-interface-support-bottom-up-deletion.patch) at 2020-11-17 21:38:05 from Peter Geoghegan <pg at bowt.ie> (Patch: Yes)
    Attachment (20201114-results-master.txt) at 2020-11-15 22:29:08 from Victor Yegorov <vyegorov at gmail.com> (Patch: No)
    Attachment (v8-0001-Deprecate-nbtree-s-BTP_HAS_GARBAGE-flag.patch) at 2020-11-12 23:00:49 from Peter Geoghegan <pg at bowt.ie> (Patch: Yes)
    Attachment (20201111-results-master.txt) at 2020-11-11 20:58:06 from Victor Yegorov <vyegorov at gmail.com> (Patch: No)
    Attachment (20201110-results-master.txt) at 2020-11-11 14:17:32 from Victor Yegorov <vyegorov at gmail.com> (Patch: No)
    Attachment (v7-0004-Teach-heapam-to-support-bottom-up-index-deletion.patch) at 2020-11-09 17:20:50 from Peter Geoghegan <pg at bowt.ie> (Patch: Yes)
    Attachment (v6-0001-Add-delete-deduplication-to-nbtree.patch) at 2020-11-03 20:44:10 from Peter Geoghegan <pg at bowt.ie> (Patch: Yes)
    Attachment (20201028-v5-results.txt) at 2020-10-28 23:05:01 from Victor Yegorov <vyegorov at gmail.com> (Patch: No)
    Attachment (v5-0001-Add-sort_template.h-for-making-fast-sort-function.patch) at 2020-10-26 21:15:03 from Peter Geoghegan <pg at bowt.ie> (Patch: Yes)
    Attachment (v4-0001-Add-sort_template.h-for-making-fast-sort-function.patch) at 2020-10-20 02:37:16 from Peter Geoghegan <pg at bowt.ie> (Patch: Yes)
    Attachment (v3-0001-Add-delete-deduplication-to-nbtree.patch) at 2020-10-16 20:58:01 from Peter Geoghegan <pg at bowt.ie> (Patch: Yes)
    Attachment (v2-0001-Add-delete-deduplication-to-nbtree.patch) at 2020-10-12 21:45:00 from Peter Geoghegan <pg at bowt.ie> (Patch: Yes)
    Attachment (0001-Non-opportunistically-delete-B-Tree-items.patch) at 2020-07-01 00:03:25 from Peter Geoghegan <pg at bowt.ie> (Patch: Yes)
History
When Who What
2021-01-13 20:46:52 Peter Geoghegan (pgeoghegan) Closed in commitfest 2021-01 with status: Committed
2021-01-13 20:46:52 Peter Geoghegan (pgeoghegan) Changed committer to pgeoghegan
2020-12-01 11:05:39 Anastasia Lubennikova (lubennikovaav) Closed in commitfest 2020-11 with status: Moved to next CF
2020-11-09 18:45:59 Peter Geoghegan (pgeoghegan) Changed name to Bottom-up index deletion (targets old duplicate versions from non-HOT updates)
2020-10-08 22:41:29 Peter Geoghegan (pgeoghegan) Changed authors to Peter Geoghegan (pgeoghegan)
2020-10-08 22:41:29 Peter Geoghegan (pgeoghegan) Changed targetversion to 14
2020-10-08 22:41:04 Peter Geoghegan (pgeoghegan) Attached mail thread CAH2-Wzm+maE3apHB8NOtmM=p-DO65j2V5GzAWCOEEuy3JZgb2g@mail.gmail.com
2020-10-08 22:41:04 Peter Geoghegan (pgeoghegan) Created patch record
Edit