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

Edit
ID 3461
Title In-place persistence change of a relation (fast ALTER TABLE ... SET LOGGED with wal_level=minimal)
CI (CFBot) Not processed
Stats (from CFBot) Unknown
Topic Performance
Tags
Created 2021-12-17 08:47:01
Last modified 2024-11-30 05:15:08 (11 months ago)
Latest email 2024-12-27 08:25:02 (10 months ago)
Status
2025-01 (2025-01-01 – 2025-01-31): Waiting on Author
2024-11 (2024-11-01 – 2024-11-30): Moved to different CF
2024-09 (2024-09-01 – 2024-09-30): Moved to different CF
2024-07 (2024-07-01 – 2024-07-31): Moved to different CF
2024-03 (2024-03-01 – 2024-04-08): Moved to different CF
2024-01 (2024-01-01 – 2024-01-31): Moved to different CF
2023-11 (2023-11-01 – 2023-12-04): Moved to different CF
2023-09 (2023-09-01 – 2023-09-30): Moved to different CF
2023-07 (2023-07-01 – 2023-07-31): Moved to different CF
2023-03 (2023-03-01 – 2023-04-08): Moved to different CF
2023-01 (2023-01-01 – 2023-01-31): Moved to different CF
2022-11 (2022-11-01 – 2022-11-30): Moved to different CF
2022-09 (2022-09-01 – 2022-09-30): Moved to different CF
2022-07 (2022-07-01 – 2022-07-31): Moved to different CF
2022-03 (2022-03-01 – 2022-03-31): Moved to different CF
2022-01 (2022-01-01 – 2022-01-31): Moved to different CF
Target version
Authors Kyotaro Horiguchi (horiguti)
Reviewers Heikki Linnakangas (heikki), Justin Pryzby (justinpryzby), Jakub Wartak (jakub.wartak.tomtom)Become reviewer
Committer
Links
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-12-27 08:25:02 by Kyotaro Horiguchi <horikyota.ntt at gmail.com>
Latest attachment (v36-0001-Add-XLOG-resource-for-the-undo-log-system.patch) at 2024-12-27 08:25:02 from Kyotaro Horiguchi <horikyota.ntt at gmail.com>
    Attachment (v36-0001-Add-XLOG-resource-for-the-undo-log-system.patch) at 2024-12-27 08:25:02 from Kyotaro Horiguchi <horikyota.ntt at gmail.com> (Patch: Yes)
    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
2025-06-09 16:01:49 Nathan Bossart (bossartn) Removed bossartn from reviewers
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