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

Edit
Comment/Review
Change Status
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 2023-12-04 09:16:40 (2 days, 21 hours ago)
Latest email 2023-09-04 08:37:48 (3 months ago)
Status
2024-01: Needs review
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 Nathan Bossart (bossartn), 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 2023-09-04 08:37:48 by Kyotaro Horiguchi <horikyota.ntt at gmail.com>
Latest attachment (v29-0001-Introduce-undo-log-implementation.patch) at 2023-09-04 08:37:48 from Kyotaro Horiguchi <horikyota.ntt at gmail.com>
    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
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