VACUUM FULL / CLUSTER CONCURRENTLY

Edit
ID 5117
Title VACUUM FULL / CLUSTER CONCURRENTLY
CI (CFBot) Summary
Stats (from CFBot) Patch count: 4, First patch: +43−31, All patches: +3825−317
Tags DDL
Created 2024-07-10 07:19:52
Last modified 2026-02-03 18:42:38 (1 month ago)
Latest email 2026-03-25 20:12:48 (8 hours ago)
Status
PG19-Final (2026-03-01 – 2026-03-31): Needs review
PG19-3 (2025-11-01 – 2025-11-30): Moved to different CF
PG19-Drafts (2025-06-22 – 2026-02-28): Moved to different CF
PG19-2 (2025-09-01 – 2025-09-30): Moved to different CF
PG19-1 (2025-07-01 – 2025-07-31): Moved to different CF
2025-03 (2025-03-01 – 2025-04-08): Moved to different CF
2025-01 (2025-01-01 – 2025-01-31): Moved to different CF
2024-11 (2024-11-01 – 2024-11-30): Moved to different CF
2024-09 (2024-09-01 – 2024-09-30): Moved to different CF
Target version
Authors Antonin Houska (a.houska)
Reviewers Álvaro Herrera (alvherre), Mihail Nikalayeu (mihailnikalayeu)Become reviewer
Committer
Links
Emails
why there is not VACUUM FULL CONCURRENTLY?
First at 2024-01-30 08:01:57 by Pavel Stehule <pavel.stehule at gmail.com>
Latest at 2025-07-21 16:48:52 by Alvaro Herrera <alvherre at alvh.no-ip.org>
Latest attachment (v15-0001-Add-REPACK-command.patch) at 2025-06-30 18:22:05 from Antonin Houska <ah at cybertec.at>
    Attachment (v15-0001-Add-REPACK-command.patch) at 2025-06-30 18:22:05 from Antonin Houska <ah at cybertec.at> (Patch: Yes)
    Attachment (v14-0001-Add-REPACK-command.patch) at 2025-06-09 10:19:15 from Antonin Houska <ah at cybertec.at> (Patch: Yes)
    Attachment (v13-0001-Add-REPACK-command.patch) at 2025-04-11 09:25:22 from Antonin Houska <ah at cybertec.at> (Patch: Yes)
    Attachment (0001-Add-REPACK-command.patch) at 2025-04-04 16:38:54 from Antonin Houska <ah at cybertec.at> (Patch: Yes)
    Attachment (v12-0001-Add-REPACK-command.patch) at 2025-04-01 13:31:31 from Antonin Houska <ah at cybertec.at> (Patch: Yes)
    Attachment (v11-0001-Add-REPACK-command.patch) at 2025-03-31 14:26:25 from Antonin Houska <ah at cybertec.at> (Patch: Yes)
    Attachment (v10-0001-Add-REPACK-command.patch) at 2025-03-25 14:32:46 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (v09-0001-Add-REPACK-command.patch) at 2025-03-20 17:32:02 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (v08-0001-Add-REPACK-command.patch) at 2025-02-26 08:48:08 from Antonin Houska <ah at cybertec.at> (Patch: Yes)
    Attachment (0001-Add-REPACK-command.patch) at 2025-02-19 17:08:02 from Antonin Houska <ah at cybertec.at> (Patch: Yes)
    Attachment (v07-0002-Move-progress-related-fields-from-PgBackendStatus-to.patch) at 2025-01-13 13:48:31 from Antonin Houska <ah at cybertec.at> (Patch: Yes)
    Attachment (v06-0001-Adjust-signature-of-cluster_rel-and-its-subroutines.patch) at 2024-12-11 18:29:57 from Antonin Houska <ah at cybertec.at> (Patch: Yes)
    Attachment (0001-Minor-code-review.patch.nocfbot) at 2024-12-06 13:46:01 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (v05-0001-Adjust-signature-of-cluster_rel-and-its-subroutines.patch) at 2024-10-09 12:56:17 from Antonin Houska <ah at cybertec.at> (Patch: Yes)
    Attachment (v04-0001-Adjust-signature-of-cluster_rel-and-its-subroutines.patch) at 2024-09-06 08:08:35 from Antonin Houska <ah at cybertec.at> (Patch: Yes)
    Attachment (v03-0001-Adjust-signature-of-cluster_rel-and-its-subroutines.patch) at 2024-09-04 11:41:35 from Antonin Houska <ah at cybertec.at> (Patch: Yes)
    Attachment (v02-0001-Adjust-signature-of-cluster_rel-and-its-subroutines.patch) at 2024-08-27 12:00:50 from Antonin Houska <ah at cybertec.at> (Patch: Yes)
    Attachment (vacuum_full_concurrently_v01.tar) at 2024-07-09 16:03:29 from Antonin Houska <ah at cybertec.at> (Patch: No)
    Attachment (v01-0001-Adjust-signature-of-cluster_rel-and-its-subroutines.patch) at 2024-07-09 15:55:58 from Antonin Houska <ah at cybertec.at> (Patch: Yes)
Adding REPACK [concurrently]
First at 2025-07-26 21:56:04 by Alvaro Herrera <alvherre at alvh.no-ip.org>
Latest at 2026-03-25 20:12:48 by Alvaro Herrera <alvherre at alvh.no-ip.org>
Latest attachment (v44b-0001-Make-index_concurrently_create_copy-more-genera.patch) at 2026-03-25 20:12:48 from Alvaro Herrera <alvherre at alvh.no-ip.org>
    Attachment (v44b-0001-Make-index_concurrently_create_copy-more-genera.patch) at 2026-03-25 20:12:48 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (0001-Check-for-transaction-block-early-in-ExecRepack.patch) at 2026-03-25 15:52:16 from Srinath Reddy Sadipiralla <srinath2133 at gmail.com> (Patch: Yes)
    Attachment (v44-0001-Make-index_concurrently_create_copy-more-general.patch) at 2026-03-24 22:32:17 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (nocfbot-0001-Fix-REPACK-to-skip-temporary-tables-of-other-sess.patch) at 2026-03-23 16:07:24 from Jim Jones <jim.jones at uni-muenster.de> (Patch: Yes)
    Attachment (nocfbot-Reproduce-filtering-issue.patch) at 2026-03-23 12:00:34 from Antonin Houska <ah at cybertec.at> (Patch: Yes)
    Attachment (v43-0001-Refactor-index_concurrently_create_copy-for-use-.patch) at 2026-03-19 19:52:37 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (fix_diff.norobots) at 2026-03-18 19:12:19 from Srinath Reddy Sadipiralla <srinath2133 at gmail.com> (Patch: Yes)
    Attachment (v42-0001-Refactor-index_concurrently_create_copy-for-use-with.patch) at 2026-03-17 19:57:06 from Antonin Houska <ah at cybertec.at> (Patch: Yes)
    Attachment (0001-Fix-a-few-problems-in-index-build-progress-reporting.nocfbot.patch) at 2026-03-16 13:46:02 from Antonin Houska <ah at cybertec.at> (Patch: Yes)
    Attachment (0001-rewrite-infinite-loop-in-our-style.nocfbot.txt) at 2026-03-12 19:31:40 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (v41-0001-Refactor-index_concurrently_create_copy-for-use-with.patch) at 2026-03-11 15:54:22 from Antonin Houska <ah at cybertec.at> (Patch: Yes)
    Attachment (pg_stat_progress_repack_doc_v1.diff) at 2026-03-11 01:13:29 from "Shinoda, Noriyoshi (PSD Japan FSI)" <noriyoshi.shinoda at hpe.com> (Patch: Yes)
    Attachment (v40-0001-Refactor-index_concurrently_create_copy-for-use-.patch) at 2026-03-10 19:24:25 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (v39-0001-Add-REPACK-command.patch) at 2026-03-09 10:43:44 from Antonin Houska <ah at cybertec.at> (Patch: Yes)
    Attachment (nocfbot-review_changes.patch) at 2026-03-07 14:28:00 from Mihail Nikalayeu <mihailnikalayeu at gmail.com> (Patch: Yes)
    Attachment (v38-0001-Add-REPACK-command.patch) at 2026-03-05 19:06:13 from Antonin Houska <ah at cybertec.at> (Patch: Yes)
    Attachment (v37-0001-Add-REPACK-command.patch) at 2026-03-02 14:39:01 from Antonin Houska <ah at cybertec.at> (Patch: Yes)
    Attachment (v36-0001-Add-REPACK-command.patch) at 2026-02-27 18:38:29 from Antonin Houska <ah at cybertec.at> (Patch: Yes)
    Attachment (setup.sql) at 2026-02-25 13:55:42 from Srinath Reddy Sadipiralla <srinath2133 at gmail.com> (Patch: No)
    Attachment (v35-0001-Add-REPACK-command.patch) at 2026-02-23 18:23:52 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (v34-0001-Add-REPACK-command.patch) at 2026-02-16 19:56:18 from Antonin Houska <ah at cybertec.at> (Patch: Yes)
    Attachment (nocfbot-vX-0001-stress-tests-for-repack-concurrently.patch) at 2026-02-07 14:16:27 from Mihail Nikalayeu <mihailnikalayeu at gmail.com> (Patch: Yes)
    Attachment (v33-0001-Add-REPACK-command.patch) at 2026-02-06 15:08:27 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (vX-0001-Handle-VACUUM-interaction-with-REPACK-CONCURRENTL.patch) at 2026-02-01 19:46:31 from Mihail Nikalayeu <mihailnikalayeu at gmail.com> (Patch: Yes)
    Attachment (v32-0001-Add-REPACK-command.patch) at 2026-01-27 10:57:36 from Antonin Houska <ah at cybertec.at> (Patch: Yes)
    Attachment (nocfbot-stress_tests_for_repack_concurrently.patch) at 2026-01-25 16:31:00 from Mihail Nikalayeu <mihailnikalayeu at gmail.com> (Patch: Yes)
    Attachment (v31-0001-Add-REPACK-command.patch) at 2026-01-22 08:37:40 from Antonin Houska <ah at cybertec.at> (Patch: Yes)
    Attachment (v30-0001-Add-REPACK-command.patch) at 2026-01-12 16:33:30 from Antonin Houska <ah at cybertec.at> (Patch: Yes)
    Attachment (v29-0001-Add-REPACK-command.patch) at 2026-01-08 16:59:00 from Antonin Houska <ah at cybertec.at> (Patch: Yes)
    Attachment (v28-0001-Add-REPACK-command.patch) at 2025-12-13 18:48:39 from Antonin Houska <ah at cybertec.at> (Patch: Yes)
    Attachment (nocfbot-0006-Preserve-visibility-information-of-the-conc.patch) at 2025-12-13 18:45:28 from Mihail Nikalayeu <mihailnikalayeu at gmail.com> (Patch: Yes)
    Attachment (v27-0001-Add-REPACK-command.patch) at 2025-12-09 18:52:37 from Antonin Houska <ah at cybertec.at> (Patch: Yes)
    Attachment (v26-0001-Add-REPACK-command.patch) at 2025-12-04 17:43:27 from Antonin Houska <ah at cybertec.at> (Patch: Yes)
    Attachment (v25-0001-Add-REPACK-command.patch) at 2025-10-30 23:17:05 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (v24-0001-Add-REPACK-command.patch) at 2025-10-10 14:11:32 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (v23-0001-Add-REPACK-command.patch) at 2025-10-07 14:05:33 from Álvaro Herrera <alvherre at kurilemu.de> (Patch: Yes)
    Attachment (v22-0001-Split-vacuumdb-to-create-vacuuming.c-h.patch) at 2025-09-25 18:12:41 from Álvaro Herrera <alvherre at kurilemu.de> (Patch: Yes)
    Attachment (v21-0006-Preserve-visibility-information-of-the-concurren.patch) at 2025-09-02 10:44:27 from Mihail Nikalayeu <mihailnikalayeu at gmail.com> (Patch: Yes)
    Attachment (Add_test_for_REPACK_CONCURRENTLY_with_concurrent_modifications.patch_) at 2025-09-01 09:06:35 from Mihail Nikalayeu <mihailnikalayeu at gmail.com> (Patch: Yes)
    Attachment (v22-0002-Add-stress-tests-for-concurrent-index-builds.patch) at 2025-08-31 15:29:00 from Mihail Nikalayeu <mihailnikalayeu at gmail.com> (Patch: Yes)
    Attachment (v20-0001-Split-vacuumdb-to-create-vacuuming.c-h.patch) at 2025-08-31 12:09:29 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (v19-0001-Split-vacuumdb-to-create-vacuuming.c-h.patch) at 2025-08-30 17:50:56 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (v18-0006-Preserve-visibility-information-of-the-concurren.patch) at 2025-08-20 23:44:00 from Mihail Nikalayeu <mihailnikalayeu at gmail.com> (Patch: No)
    Attachment (v2-0001-Add-REPACK-command.patch) at 2025-08-19 18:53:32 from Álvaro Herrera <alvherre at kurilemu.de> (Patch: Yes)
    Attachment (v18-0001-Add-REPACK-command.patch) at 2025-08-15 12:32:09 from Antonin Houska <ah at cybertec.at> (Patch: Yes)
    Attachment (v18-0001-Add-REPACK-command.patch) at 2025-08-11 14:22:00 from Antonin Houska <ah at cybertec.at> (Patch: Yes)
    Attachment (v17-0001-Add-REPACK-command.patch) at 2025-07-31 16:50:11 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (v1-0001-Add-REPACK-command.patch) at 2025-07-26 21:56:04 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
splitting src/bin/scripts/vacuumdb.c
First at 2025-09-26 11:55:50 by Álvaro Herrera <alvherre at kurilemu.de>
Latest at 2025-09-26 14:44:49 by Álvaro Herrera <alvherre at kurilemu.de>
Latest attachment (v23-0001-Split-vacuumdb-to-create-vacuuming.c-h.patch) at 2025-09-26 11:55:50 from Álvaro Herrera <alvherre at kurilemu.de>
    Attachment (v23-0001-Split-vacuumdb-to-create-vacuuming.c-h.patch) at 2025-09-26 11:55:50 from Álvaro Herrera <alvherre at kurilemu.de> (Patch: Yes)
History
When Who What
2026-03-25 20:31:40 CFbot Patch does not need rebase anymore
2026-03-25 16:05:25 CFbot Patch needs rebase
2026-03-17 20:18:39 CFbot Patch does not need rebase anymore
2026-03-16 14:01:35 CFbot Patch needs rebase
2026-03-11 01:31:41 CFbot Patch does not need rebase anymore
2026-03-10 19:31:34 CFbot Patch needs rebase
2026-02-23 18:39:34 CFbot Patch does not need rebase anymore
2026-02-20 16:40:32 CFbot Patch needs rebase
2026-02-16 20:02:41 CFbot Patch does not need rebase anymore
2026-02-11 10:45:29 CFbot Patch needs rebase
2026-02-06 15:31:47 CFbot Patch does not need rebase anymore
2026-02-03 18:42:38 Álvaro Herrera (alvherre) Changed targetversion to None
2026-01-29 14:14:30 Álvaro Herrera (alvherre) Changed tags to DDL
2026-01-29 08:25:28 CFbot Patch needs rebase
2026-01-22 09:15:37 CFbot Patch does not need rebase anymore
2026-01-13 14:52:29 CFbot Patch needs rebase
2026-01-13 14:50:35 Álvaro Herrera (alvherre) Moved from CF PG19-3 to CF PG19-Final
2025-12-04 18:13:27 CFbot Patch does not need rebase anymore
2025-11-26 02:46:30 CFbot Patch needs rebase
2025-10-07 14:20:27 CFbot Patch does not need rebase anymore
2025-10-07 14:17:16 Álvaro Herrera (alvherre) Moved from CF PG19-Drafts to CF PG19-3
2025-10-07 07:47:43 Mihail Nikalayeu (mihailnikalayeu) Moved from CF PG19-2 to CF PG19-Drafts
2025-09-26 18:13:20 CFbot Patch needs rebase
2025-09-26 15:09:24 CFbot Patch does not need rebase anymore
2025-09-26 14:47:23 CFbot Patch needs rebase
2025-09-26 11:56:12 Álvaro Herrera (alvherre) Attached mail thread 202509261126.lqdaq6uvo2m2@alvherre.pgsql
2025-08-30 18:01:34 CFbot Patch does not need rebase anymore
2025-08-21 03:25:13 Mihail Nikalayeu (mihailnikalayeu) Added mihailnikalayeu as reviewer
2025-08-21 00:11:17 CFbot Patch needs rebase
2025-08-14 08:35:28 CFbot Patch does not need rebase anymore
2025-08-12 14:44:09 Álvaro Herrera (alvherre) Moved from CF PG19-1 to CF PG19-2
2025-08-12 14:43:59 Álvaro Herrera (alvherre) Attached mail thread 202507262156.sb455angijk6@alvherre.pgsql
2025-07-23 23:56:24 CFbot Patch needs rebase
2025-07-07 21:04:38 Álvaro Herrera (alvherre) Added alvherre as reviewer
2025-06-30 18:31:52 CFbot Patch does not need rebase anymore
2025-06-26 21:13:39 CFbot Patch needs rebase
2025-06-09 10:50:39 CFbot Patch does not need rebase anymore
2025-06-09 09:48:30 CFbot Patch needs rebase
2025-06-09 09:45:21 Antonin Houska (a.houska) Closed in commitfest 2025-03 with status: Moved to next CF
2025-03-21 17:51:39 Álvaro Herrera (alvherre) New status: Needs review
2025-03-20 18:01:46 CFbot Patch does not need rebase anymore
2025-03-11 04:15:12 vigneshwaran C (vignesh.postgres) New status: Waiting on Author
2025-03-05 18:33:32 CFbot Patch needs rebase
2025-02-19 17:31:40 CFbot Patch does not need rebase anymore
2025-02-19 09:18:58 CFbot Patch needs rebase
2025-02-19 09:17:35 Jelte Fennema-Nio (jeltef) Closed in commitfest 2025-01 with status: Moved to next CF
2024-11-30 06:42:56 Kirill Reshke (reshke) Closed in commitfest 2024-11 with status: Moved to next CF
2024-10-09 13:00:14 Antonin Houska (a.houska) Closed in commitfest 2024-09 with status: Moved to next CF
2024-10-09 12:57:11 Antonin Houska (a.houska) New status: Needs review
2024-10-08 02:06:33 Michael Paquier (michael-kun) Closed in commitfest 2024-09 with status: Returned with feedback
2024-07-10 07:20:30 Antonin Houska (a.houska) Changed authors to Antonin Houska (a.houska)
2024-07-10 07:20:30 Antonin Houska (a.houska) Changed targetversion to 18
2024-07-10 07:19:52 Antonin Houska (a.houska) Attached mail thread CAFj8pRDK89FtY_yyGw7-MW-zTaHOCY4m6qfLRittdoPocz+dMQ@mail.gmail.com
2024-07-10 07:19:52 Antonin Houska (a.houska) Created patch record
Edit