In-place persistence change of a relation (fast ALTER TABLE ... SET LOGGED with wal_level=minimal)

Edit
Comment/Review
Change Status
ID 3461
Title In-place persistence change of a relation (fast ALTER TABLE ... SET LOGGED with wal_level=minimal)
Topic Performance
Created 2021-12-17 08:47:01
Last modified 2024-11-30 05:15:08 (3 days, 11 hours ago)
Latest email 2024-11-11 01:25:47 (3 weeks, 1 day ago)
Status
2025-01: Waiting on Author
2024-11: Moved to next CF
2024-09: Moved to next CF
2024-07: Moved to next CF
2024-03: Moved to next CF
2024-01: Moved to next CF
2023-11: Moved to next CF
2023-09: Moved to next CF
2023-07: Moved to next CF
2023-03: Moved to next CF
2023-01: Moved to next CF
2022-11: Moved to next CF
2022-09: Moved to next CF
2022-07: Moved to next CF
2022-03: Moved to next CF
2022-01: Moved to next CF
Target version
Authors Kyotaro Horiguchi (horiguti)
Reviewers Heikki Linnakangas (heikki), Nathan Bossart (bossartn), Justin Pryzby (justinpryzby), Jakub Wartak (jakub.wartak.tomtom)Become reviewer
Committer
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/3461
git checkout commitfest/cf/3461
Emails
In-placre persistance change of a relation
First at 2020-11-11 08:33:17 by Kyotaro Horiguchi <horikyota.ntt at gmail.com>
Latest at 2024-11-11 01:25:47 by Kyotaro Horiguchi <horikyota.ntt at gmail.com>
Latest attachment (v35-0001-Add-XLOG-resource-for-the-undo-log-system.patch) at 2024-10-31 08:01:30 from Kyotaro Horiguchi <horikyota.ntt at gmail.com>
    Attachment (v35-0001-Add-XLOG-resource-for-the-undo-log-system.patch) at 2024-10-31 08:01:30 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (v34-0001-Export-wal_sync_method-related-functions.patch) at 2024-08-31 16:09:25 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (v33-0001-Export-wal_sync_method-related-functions.patch) at 2024-05-24 07:09:16 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (v32-0001-Export-wal_sync_method-related-functions.patch) at 2024-01-23 04:15:21 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (v31-0001-Export-wal_sync_method-related-functions.patch) at 2024-01-15 07:50:59 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (v29-0001-Introduce-undo-log-implementation.patch) at 2023-09-04 08:37:48 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (v29-0001-Introduce-storage-mark-files.patch) at 2023-08-14 19:38:48 from Nathan Bossart <nathandbossart at gmail.com> (Patch: Yes)
    Attachment (v28-0001-Introduce-storage-mark-files.patch) at 2023-04-25 07:54:57 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (v27-0001-Storage-mark-files.patch) at 2023-03-17 06:16:34 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (v26-0001-Storage-mark-files.patch) at 2023-03-03 09:03:53 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (v25-0001-In-place-table-persistence-change.patch) at 2022-11-18 08:25:11 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (v24-0001-In-place-table-persistence-change.patch) at 2022-09-28 08:21:19 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (v23-0001-In-place-table-persistence-change.patch) at 2022-07-19 04:33:33 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (v22-0001-In-place-table-persistence-change.patch) at 2022-07-07 08:24:59 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (v21-0001-In-place-table-persistence-change.patch) at 2022-03-31 09:33:18 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (v20-0001-In-place-table-persistence-change.patch) at 2022-03-31 04:58:45 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (v19-0001-In-place-table-persistence-change.patch) at 2022-03-01 08:50:30 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (v18-0001-In-place-table-persistence-change.patch) at 2022-03-01 05:14:13 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (v17-0001-In-place-table-persistence-change.patch) at 2022-01-19 00:39:07 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (v16-0001-In-place-table-persistence-change.patch) at 2022-01-14 02:43:10 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (v15-0001-In-place-table-persistence-change.patch) at 2022-01-07 08:29:55 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (v14-0001-In-place-table-persistence-change.patch) at 2022-01-06 04:30:17 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (v13-0001-In-place-table-persistence-change.patch) at 2021-12-23 06:33:35 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (v12-0001-In-place-table-persistence-change.patch) at 2021-12-23 06:01:41 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (v11-0001-In-place-table-persistence-change.patch) at 2021-12-22 06:13:27 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (v10-0001-In-place-table-persistence-change.patch) at 2021-12-21 11:04:55 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (v9-0001-In-place-table-persistence-change.patch) at 2021-12-20 07:53:20 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (v8-0001-In-place-table-persistence-change.patch) at 2021-12-20 06:28:23 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (0001-In-place-table-persistence-change-with-new-command-A.patch) at 2021-12-17 19:10:28 from Justin Pryzby <pryzby at telsasoft.com> (Patch: Yes)
    Attachment (v7-0001-In-place-table-persistence-change-with-new-comman.patch) at 2021-12-17 09:10:30 from Jakub Wartak <Jakub.Wartak at tomtom.com> (Patch: Yes)
    Attachment (v6-0001-In-place-table-persistence-change.patch) at 2021-03-25 05:08:05 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (v5-0001-In-place-table-persistence-change.patch) at 2021-01-14 08:32:17 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (v4-0001-In-place-table-persistence-change.patch) at 2021-01-12 09:58:08 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (v3-0001-In-place-table-persistence-change.patch) at 2021-01-08 05:47:05 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (v2-0001-In-place-table-persistence-change.patch) at 2020-12-25 00:12:52 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (v3-0001-In-place-table-persistence-change.patch) at 2020-11-13 04:22:01 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    Attachment (PoC_in-place_set_persistence_v2.patch) at 2020-11-11 08:33:17 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
History
When Who What
2024-11-30 05:15:08 Kirill Reshke (reshke) Closed in commitfest 2024-11 with status: Moved to next CF
2024-11-11 15:09:53 Heikki Linnakangas (heikki) Added heikki as reviewer
2024-10-07 06:51:23 Michael Paquier (michael-kun) Closed in commitfest 2024-09 with status: Moved to next CF
2024-08-01 02:04:33 Corey Huinker (coreyh) Closed in commitfest 2024-07 with status: Moved to next CF
2024-06-04 00:13:38 Michael Paquier (michael-kun) New status: Waiting on Author
2024-04-08 14:07:33 Andrey Borodin (x4m) Closed in commitfest 2024-03 with status: Moved to next CF
2024-02-01 17:37:46 vigneshwaran C (vignesh.postgres) Closed in commitfest 2024-01 with status: Moved to next CF
2023-12-04 09:16:40 John Naylor (john.naylor) Closed in commitfest 2023-11 with status: Moved to next CF
2023-10-02 11:04:01 Peter Eisentraut (petere) Closed in commitfest 2023-09 with status: Moved to next CF
2023-08-14 19:38:52 Nathan Bossart (bossartn) Added bossartn as reviewer
2023-08-02 19:32:10 Daniel Gustafsson (d_gustafsson) Closed in commitfest 2023-07 with status: Moved to next CF
2023-04-05 15:35:30 Greg Stark (stark) Changed targetversion to None
2023-04-05 01:24:18 Kyotaro Horiguchi (horiguti) Closed in commitfest 2023-03 with status: Moved to next CF
2023-03-03 14:55:15 Justin Pryzby (justinpryzby) New status: Needs review
2023-03-01 19:56:27 Greg Stark (stark) New status: Waiting on Author
2023-01-31 16:16:10 vigneshwaran C (vignesh.postgres) Closed in commitfest 2023-01 with status: Moved to next CF
2022-12-13 07:36:52 Ian Barwick (barwick) Closed in commitfest 2022-11 with status: Moved to next CF
2022-11-27 08:09:04 Ian Barwick (barwick) New status: Needs review
2022-10-12 08:25:18 Michael Paquier (michael-kun) Closed in commitfest 2022-09 with status: Moved to next CF
2022-10-12 08:25:14 Michael Paquier (michael-kun) New status: Waiting on Author
2022-08-01 22:49:51 Jacob Champion (jchampion) Closed in commitfest 2022-07 with status: Moved to next CF
2022-03-31 13:26:55 Justin Pryzby (justinpryzby) New status: Needs review
2022-03-31 09:34:32 Kyotaro Horiguchi (horiguti) Closed in commitfest 2022-03 with status: Moved to next CF
2022-03-31 09:34:21 Kyotaro Horiguchi (horiguti) Changed targetversion to 16
2022-03-31 05:37:54 Justin Pryzby (justinpryzby) Changed targetversion to None
2022-03-30 13:43:02 Justin Pryzby (justinpryzby) New status: Waiting on Author
2022-02-02 16:33:50 Julien Rouhaud (rjuju) Closed in commitfest 2022-01 with status: Moved to next CF
2022-01-20 21:30:08 Justin Pryzby (justinpryzby) New status: Needs review
2022-01-18 06:27:04 Julien Rouhaud (rjuju) New status: Waiting on Author
2022-01-11 09:33:55 Jakub Wartak (jakub.wartak.tomtom) Posted review with messageid <164189363522.31345.3832968263786650864.pgcf@coridan.postgresql.org>
2022-01-11 09:33:55 Jakub Wartak (jakub.wartak.tomtom) New status: Needs review
2022-01-10 23:10:15 Justin Pryzby (justinpryzby) Changed name to In-place persistence change of a relation (fast ALTER TABLE ... SET LOGGED with wal_level=minimal)
2021-12-22 08:47:07 Jakub Wartak (jakub.wartak.tomtom) Changed reviewers to Justin Pryzby (justinpryzby), Jakub Wartak (jakub.wartak.tomtom)
2021-12-20 07:07:15 Jakub Wartak (jakub.wartak.tomtom) Changed authors to Kyotaro Horiguchi (horiguti)
2021-12-17 19:52:56 Justin Pryzby (justinpryzby) Added justinpryzby as reviewer
2021-12-17 19:52:49 Justin Pryzby (justinpryzby) Changed authors to Kyotaro Horiguchi (horiguti), Jakub Wartak (jakub.wartak.tomtom)
2021-12-17 19:52:26 Justin Pryzby (justinpryzby) New status: Waiting on Author
2021-12-17 08:47:23 Jakub Wartak (jakub.wartak.tomtom) Changed authors to Kyotaro Horiguchi (horiguti)
2021-12-17 08:47:23 Jakub Wartak (jakub.wartak.tomtom) Changed targetversion to 15
2021-12-17 08:47:02 Jakub Wartak (jakub.wartak.tomtom) Attached mail thread 20201111.173317.460890039962481381.horikyota.ntt@gmail.com
2021-12-17 08:47:01 Jakub Wartak (jakub.wartak.tomtom) Created patch record
Edit
Comment/Review
Change Status