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

Edit
ID 2757
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 (3 years, 9 months ago)
Latest email 2021-01-26 18:40:31 (3 years, 9 months 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 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/2757
git checkout commitfest/cf/2757
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