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

Edit
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 2022-08-01 22:49:51 (1 month, 4 weeks ago)
Latest email 2022-09-28 08:21:19 (2 days, 1 hour ago)
Status
2022-09: Needs review
2022-07: Moved to next CF
2022-03: Moved to next CF
2022-01: Moved to next CF
Target version 16
Authors Kyotaro Horiguchi (horiguti)
Reviewers 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 2022-09-28 08:21:19 by Kyotaro Horiguchi <horikyota.ntt at gmail.com>
Latest attachment (v24-0001-In-place-table-persistence-change.patch) at 2022-09-28 08:21:19 from Kyotaro Horiguchi <horikyota.ntt at gmail.com>
    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
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