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

Edit

ID

Title

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

CI (CFBot)

Not processed

Stats (from CFBot)

Unknown

Topic

Performance

Tags

Created

2020-10-08 22:41:04

Last modified

2021-01-13 20:46:52 (4 years ago)

Latest email

2021-01-26 18:40:31 (4 years ago)

Status

2021-01 (2021-01-01 – 2021-01-31): Committed

2020-11 (2020-11-01 – 2020-11-30): Moved to different 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