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

Edit

Title

Topic

Performance

Created

2021-12-17 08:47:01

Last modified

2023-04-05 15:35:30 (2 months ago)

Latest email

2023-04-28 01:58:53 (1 month, 1 week ago)

Status

2023-07: Needs review

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

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-04-28 01:58:53 by Kyotaro Horiguchi <horikyota.ntt at gmail.com>
Latest attachment (v28-0001-Introduce-storage-mark-files.patch) at 2023-04-25 07:54:57 from Kyotaro Horiguchi <horikyota.ntt at gmail.com>
    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-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