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

Edit

3461

Title

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 (7 months ago)

Latest email

2024-12-27 08:25:02 (6 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