Improve dead tuple storage for lazy vacuum

Edit
Title Improve dead tuple storage for lazy vacuum
Topic Performance
Created 2022-06-16 04:57:20
Last modified 2023-02-01 04:38:58 (6 days, 4 hours ago)
Latest email 2023-01-31 14:42:32 (6 days, 18 hours ago)
Status
2023-03: Needs review
2023-01: Moved to next CF
2022-11: Moved to next CF
2022-09: Moved to next CF
2022-07: Moved to next CF
Target version
Authors Masahiko Sawada (masahikosawada)
Reviewers John Naylor (john.naylor)Become reviewer
Committer
Links
Emails
[PoC] Improve dead tuple storage for lazy vacuum
First at 2021-07-07 11:46:38 by Masahiko Sawada <sawada.mshk at gmail.com>
Latest at 2023-01-31 14:42:32 by Masahiko Sawada <sawada.mshk at gmail.com>
Latest attachment (v24-0005-Add-read-write-lock-to-radix-tree-in-RT_SHMEM-ca.patch) at 2023-01-31 14:42:32 from Masahiko Sawada <sawada.mshk at gmail.com>
    Attachment (v24-0005-Add-read-write-lock-to-radix-tree-in-RT_SHMEM-ca.patch) at 2023-01-31 14:42:32 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (remove-intermediate-variables.txt) at 2023-01-28 11:32:50 from John Naylor <john.naylor at enterprisedb.com> (Patch: Yes)
    Attachment (v23-0016-Add-read-write-lock-to-radix-tree-in-RT_SHMEM-ca.patch) at 2023-01-26 14:47:40 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v22-0002-Move-some-bitmap-logic-out-of-bitmapset.c.patch) at 2023-01-23 12:29:33 from John Naylor <john.naylor at enterprisedb.com> (Patch: Yes)
    Attachment (v21-0002-Move-some-bitmap-logic-out-of-bitmapset.c.patch) at 2023-01-23 11:20:06 from John Naylor <john.naylor at enterprisedb.com> (Patch: Yes)
    Attachment (v20-0013-Use-TIDStore-for-storing-dead-tuple-TID-during-l.patch) at 2023-01-19 15:18:02 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (link_pgport_src.patch) at 2023-01-18 15:49:04 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v19-0001-introduce-vector8_min-and-vector8_highbit_mask.patch) at 2023-01-17 11:05:59 from John Naylor <john.naylor at enterprisedb.com> (Patch: Yes)
    Attachment (v18-0002-Move-some-bitmap-logic-out-of-bitmapset.c.patch) at 2023-01-16 05:01:57 from John Naylor <john.naylor at enterprisedb.com> (Patch: Yes)
    Attachment (memory.py) at 2023-01-16 02:52:30 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: No)
    Attachment (v17-0010-fix-shmem-support.patch) at 2023-01-12 14:50:32 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v17-0005-Template-out-inner-and-leaf-nodes.patch) at 2023-01-09 08:59:04 from John Naylor <john.naylor at enterprisedb.com> (Patch: Yes)
    Attachment (v16-0002-Move-some-bitmap-logic-out-of-bitmapset.c.patch) at 2022-12-23 11:47:08 from John Naylor <john.naylor at enterprisedb.com> (Patch: Yes)
    Attachment (v15-0008-PoC-calculate-memory-usage-in-radix-tree.patch) at 2022-12-20 05:03:58 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v14-0005-tool-for-measuring-radix-tree-performance.patch) at 2022-12-19 07:13:45 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v13-0002-Move-some-bitmap-logic-out-of-bitmapset.c.patch) at 2022-12-06 10:32:08 from John Naylor <john.naylor at enterprisedb.com> (Patch: Yes)
    Attachment (v12-0007-PoC-lazy-vacuum-integration.patch) at 2022-12-02 16:41:31 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v11-0006-addendum-bitmapword-node128.patch.txt) at 2022-11-30 05:51:03 from John Naylor <john.naylor at enterprisedb.com> (Patch: Yes)
    Attachment (v11-0004-Preparatory-refactoring-for-decoupling-kind-from.patch) at 2022-11-24 14:54:06 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v10-0003-tool-for-measuring-radix-tree-performance.patch) at 2022-11-21 08:06:56 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v901-0002-Make-node32-variable-sized.patch.txt) at 2022-11-18 07:48:49 from John Naylor <john.naylor at enterprisedb.com> (Patch: Yes)
    Attachment (add-random-node-search-test.patch.txt) at 2022-11-16 07:39:00 from John Naylor <john.naylor at enterprisedb.com> (Patch: Yes)
    Attachment (v9-0003-tool-for-measuring-radix-tree-performance.patch) at 2022-11-14 08:43:40 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v8-0005-PoC-lazy-vacuum-integration.patch) at 2022-11-04 15:24:23 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v8-0001-introduce-vector8_min-and-vector8_highbit_mask.patch) at 2022-10-31 05:46:53 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (0002-Add-radix-implementation.patch) at 2022-10-24 05:53:36 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (radix-v6-addendum-jcn1.tar.gz) at 2022-10-10 05:54:50 from John Naylor <john.naylor at enterprisedb.com> (Patch: No)
    Attachment (fix_bench_radix_tree.patch) at 2022-10-07 08:08:35 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v65-0001-Turn-on-per-node-counts-in-benchmark.patch) at 2022-10-07 05:29:11 from John Naylor <john.naylor at enterprisedb.com> (Patch: Yes)
    Attachment (v6addendum-bench-node16.diff.txt) at 2022-09-21 06:17:21 from John Naylor <john.naylor at enterprisedb.com> (Patch: Yes)
    Attachment (v6-0001-Support-pg_lsearch8_eq-and-pg_lsearch8_ge.patch) at 2022-09-16 06:00:31 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (radixtree_v5.patch) at 2022-07-22 01:43:09 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (radixtree_wip_v4.patch) at 2022-07-05 03:30:30 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v3-radix-review-diff-20220627.txt) at 2022-06-27 11:12:13 from John Naylor <john.naylor at enterprisedb.com> (Patch: Yes)
    Attachment (radixtree_wip_v3.patch) at 2022-06-16 04:56:55 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (radixtree_wip_v2.patch) at 2022-05-25 02:48:16 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (radixtree.patch) at 2022-05-10 01:51:46 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (bench_intset2.txt) at 2021-07-29 16:49:22 from Yura Sokolov <y.sokolov at postgrespro.ru> (Patch: No)
    Attachment (0001-integerset2.patch) at 2021-07-29 15:29:51 from Yura Sokolov <y.sokolov at postgrespro.ru> (Patch: Yes)
    Attachment (0001-svtm-specialized-vacuum-tid-map.patch) at 2021-07-25 16:07:18 from Yura Sokolov <y.sokolov at postgrespro.ru> (Patch: Yes)
    Attachment (0001-Fix-build-warnings.patch) at 2021-07-19 23:49:15 from Andres Freund <andres at anarazel.de> (Patch: Yes)
    Attachment (vacuum.svg) at 2021-07-07 11:46:38 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: No)
History
When Who What
2023-02-01 04:38:58 John Naylor (john.naylor) New status: Needs review
2023-01-31 16:44:08 vignesh C (vignesh.postgres) Closed in commitfest 2023-01 with status: Moved to next CF
2022-12-08 14:20:36 Ian Barwick (barwick) Closed in commitfest 2022-11 with status: Moved to next CF
2022-11-03 05:04:13 John Naylor (john.naylor) New status: Waiting on Author
2022-10-24 22:49:08 Justin Pryzby (justinpryzby) New status: Needs review
2022-10-12 08:24:45 Michael Paquier (michael-kun) Closed in commitfest 2022-09 with status: Moved to next CF
2022-10-12 08:24:40 Michael Paquier (michael-kun) New status: Waiting on Author
2022-08-01 21:04:25 Jacob Champion (jchampion) Closed in commitfest 2022-07 with status: Moved to next CF
2022-07-22 04:03:12 John Naylor (john.naylor) New status: Needs review
2022-07-18 05:16:08 John Naylor (john.naylor) New status: Waiting on Author
2022-06-17 03:40:26 John Naylor (john.naylor) Added john.naylor as reviewer
2022-06-16 04:57:32 Masahiko Sawada (masahikosawada) Changed authors to Masahiko Sawada (masahikosawada)
2022-06-16 04:57:21 Masahiko Sawada (masahikosawada) Attached mail thread CAD21AoAfOZvmfR0j8VmZorZjL7RhTiQdVttNuC4W-Shdc2a-AA@mail.gmail.com
2022-06-16 04:57:20 Masahiko Sawada (masahikosawada) Created patch record
Edit