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, 10 months ago)

Latest email 2021-01-26 18:40:31 (3 years, 10 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