Parallel processing of indexes in autovacuum

Edit
ID 5755
Title Parallel processing of indexes in autovacuum
CI (CFBot) Summary
Stats (from CFBot) Patch version: v37, Patch count: 1, First patch: +616−33, All patches: +616−33
Tags Performance
Created 2025-05-16 07:42:42
Last modified 2026-04-07 07:50:28 (8 hours ago)
Latest email 2026-04-07 13:32:32 (2 hours ago)
Status
PG19-Final (2026-03-01 – 2026-04-09): Committed
PG19-4 (2026-01-01 – 2026-01-31): Moved to different CF
PG19-3 (2025-11-01 – 2025-11-30): 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
Target version 18
Authors Maxim Orlov (m.orlov), Daniil Davydov (dddaniil)
Reviewers Masahiko Sawada (masahikosawada), Sami Imseih (simseih)Become reviewer
Committer Masahiko Sawada (masahikosawada)
Links
Emails
POC: Parallel processing of indexes in autovacuum
First at 2025-04-16 11:04:53 by Maxim Orlov <orlovmg at gmail.com>
Latest at 2026-04-07 13:32:32 by Daniil Davydov <3danissimo at gmail.com>
Latest attachment (v37-0001-Allow-autovacuum-to-use-parallel-vacuum-workers.patch) at 2026-04-04 01:11:58 from Masahiko Sawada <sawada.mshk at gmail.com>
    Attachment (v37-0001-Allow-autovacuum-to-use-parallel-vacuum-workers.patch) at 2026-04-04 01:11:58 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (0001-Reset-pointer-into-the-going-away-DSM.patch) at 2026-04-03 13:45:39 from Daniil Davydov <3danissimo at gmail.com> (Patch: Yes)
    Attachment (0001-Make-sure-that-all-recourses-have-been-released-in-p.patch) at 2026-04-02 15:10:46 from Daniil Davydov <3danissimo at gmail.com> (Patch: Yes)
    Attachment (0001-POC-use-proc-signals-to-propagate-the-shared-vacuum-.patch) at 2026-04-02 09:22:17 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v36-0001-Allow-autovacuum-to-use-parallel-vacuum-workers.patch) at 2026-04-01 21:24:29 from Daniil Davydov <3danissimo at gmail.com> (Patch: Yes)
    Attachment (v34-v35-diff.patch) at 2026-04-01 07:44:25 from Daniil Davydov <3danissimo at gmail.com> (Patch: Yes)
    Attachment (v34-0001-Allow-autovacuum-to-use-parallel-vacuum-workers.patch) at 2026-03-31 07:09:19 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v33-0001-Parallel-autovacuum.patch) at 2026-03-30 10:40:05 from Daniil Davydov <3danissimo at gmail.com> (Patch: Yes)
    Attachment (v32-0002-Documantation-for-parallel-autovacuum.patch) at 2026-03-28 11:10:44 from Daniil Davydov <3danissimo at gmail.com> (Patch: Yes)
    Attachment (v31-0002-fixup-several-changes.patch) at 2026-03-25 22:42:30 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v30-0003-Cost-based-parameters-propagation-for-parallel-a.patch) at 2026-03-19 14:28:57 from Daniil Davydov <3danissimo at gmail.com> (Patch: Yes)
    Attachment (v30-0001-Add-parallel-vacuum-worker-usage-to-VACUUM-VERBO.patch) at 2026-03-18 19:49:17 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v29-0005-Documentation-for-parallel-autovacuum.patch) at 2026-03-18 09:23:39 from Daniil Davydov <3danissimo at gmail.com> (Patch: Yes)
    Attachment (v28-0006-fixup-updates-tap-tests.patch) at 2026-03-17 16:50:48 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v27-0005-Documentation-for-parallel-autovacuum.patch) at 2026-03-16 20:54:43 from Daniil Davydov <3danissimo at gmail.com> (Patch: Yes)
    Attachment (v26-0006-Advanced-logging-for-parallel-autovacuum.patch) at 2026-03-16 12:33:49 from Daniil Davydov <3danissimo at gmail.com> (Patch: Yes)
    Attachment (v25-0003-Cost-based-parameters-propagation-for-parallel-a.patch) at 2026-03-11 11:28:30 from Daniil Davydov <3danissimo at gmail.com> (Patch: Yes)
    Attachment (v24-0004-Tests-for-parallel-autovacuum.patch) at 2026-03-04 06:58:49 from Daniil Davydov <3danissimo at gmail.com> (Patch: Yes)
    Attachment (change_0003_masahiko.patch) at 2026-03-02 22:25:39 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v23-0003-Cost-based-parameters-propagation-for-parallel-a.patch) at 2026-03-01 14:46:42 from Daniil Davydov <3danissimo at gmail.com> (Patch: Yes)
    Attachment (v22-0004-Tests-for-parallel-autovacuum.patch) at 2026-02-27 13:49:15 from Daniil Davydov <3danissimo at gmail.com> (Patch: Yes)
    Attachment (v21-0005-Documentation-for-parallel-autovacuum.patch) at 2026-02-10 15:03:45 from Daniil Davydov <3danissimo at gmail.com> (Patch: Yes)
    Attachment (v20-0005-Documentation-for-parallel-autovacuum.patch) at 2026-01-17 14:52:32 from Daniil Davydov <3danissimo at gmail.com> (Patch: Yes)
    Attachment (v19-0001_masahiko.patch) at 2026-01-16 22:20:14 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v19-0005-Documentation-for-parallel-autovacuum.patch) at 2026-01-16 14:10:54 from Daniil Davydov <3danissimo at gmail.com> (Patch: Yes)
    Attachment (0001_masahiko.patch) at 2026-01-15 02:13:16 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v18-0001-Parallel-autovacuum.patch) at 2026-01-07 09:51:06 from Daniil Davydov <3danissimo at gmail.com> (Patch: Yes)
    Attachment (v17-0002-Logging-for-parallel-autovacuum.patch) at 2026-01-05 20:44:02 from Daniil Davydov <3danissimo at gmail.com> (Patch: Yes)
    Attachment (v16-0003-Tests-for-parallel-autovacuum.patch) at 2025-11-23 15:02:22 from Daniil Davydov <3danissimo at gmail.com> (Patch: Yes)
    Attachment (v15-0004-Documentation-for-parallel-autovacuum.patch) at 2025-11-22 20:13:03 from Daniil Davydov <3danissimo at gmail.com> (Patch: Yes)
    Attachment (v14-0004-Documentation-for-parallel-autovacuum.patch) at 2025-11-20 19:31:45 from Sami Imseih <samimseih at gmail.com> (Patch: Yes)
    Attachment (v13-0002-Logging-for-parallel-autovacuum.patch) at 2025-10-31 07:54:12 from Daniil Davydov <3danissimo at gmail.com> (Patch: Yes)
    Attachment (v12-0004-Documentation-for-parallel-autovacuum.patch) at 2025-10-28 13:09:59 from Daniil Davydov <3danissimo at gmail.com> (Patch: Yes)
    Attachment (v11-0001-Parallel-index-autovacuum.patch) at 2025-09-15 18:50:24 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v10-0002-Logging-for-parallel-autovacuum.patch) at 2025-08-18 08:30:49 from Daniil Davydov <3danissimo at gmail.com> (Patch: Yes)
    Attachment (v9-0002-Logging-for-parallel-autovacuum.patch) at 2025-07-22 06:45:31 from Daniil Davydov <3danissimo at gmail.com> (Patch: Yes)
    Attachment (v8-0002-Logging-for-parallel-autovacuum.patch) at 2025-07-20 16:43:38 from Daniil Davydov <3danissimo at gmail.com> (Patch: Yes)
    Attachment (v7-0002-Sandbox-for-parallel-index-autovacuum.patch) at 2025-07-14 10:49:10 from Daniil Davydov <3danissimo at gmail.com> (Patch: Yes)
    Attachment (v6-0001-Parallel-index-autovacuum-with-bgworkers.patch) at 2025-07-06 08:00:32 from Daniil Davydov <3danissimo at gmail.com> (Patch: Yes)
    Attachment (v5-0002-Sandbox-for-parallel-index-autovacuum.patch) at 2025-06-18 08:03:10 from Daniil Davydov <3danissimo at gmail.com> (Patch: Yes)
    Attachment (v4-0001-Parallel-index-autovacuum-with-bgworkers.patch) at 2025-05-25 17:22:42 from Daniil Davydov <3danissimo at gmail.com> (Patch: Yes)
    Attachment (v3-0001-Parallel-index-autovacuum-with-bgworkers.patch) at 2025-05-22 07:43:57 from Daniil Davydov <3danissimo at gmail.com> (Patch: Yes)
    Attachment (v2-0002-Sandbox-for-parallel-index-autovacuum.patch) at 2025-05-16 05:10:10 from Daniil Davydov <3danissimo at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Parallel-index-autovacuum-with-bgworkers.patch) at 2025-05-09 18:33:45 from Daniil Davydov <3danissimo at gmail.com> (Patch: Yes)
    Attachment (v2-0001-WIP-Allow-autovacuum-to-process-indexes-of-single.patch) at 2025-05-02 18:49:58 from Daniil Davydov <3danissimo at gmail.com> (Patch: Yes)
    Attachment (WIP-Allow-autovacuum-to-process-indexes-of-single-table.patch) at 2025-04-16 11:04:53 from Maxim Orlov <orlovmg at gmail.com> (Patch: Yes)
History
When Who What
2026-04-07 07:50:28 Masahiko Sawada (masahikosawada) Closed in commitfest PG19-Final with status: Committed
2026-04-07 07:50:28 Masahiko Sawada (masahikosawada) Changed committer to masahikosawada
2026-04-04 01:32:37 CFbot Patch does not need rebase anymore
2026-04-03 14:05:26 CFbot Patch needs rebase
2026-04-02 15:40:33 CFbot Patch does not need rebase anymore
2026-04-01 15:19:29 CFbot Patch needs rebase
2026-03-30 11:02:33 CFbot Patch does not need rebase anymore
2026-03-28 11:43:25 CFbot Patch needs rebase
2026-03-25 23:02:41 CFbot Patch does not need rebase anymore
2026-03-19 14:34:31 CFbot Patch needs rebase
2026-03-18 20:14:32 CFbot Patch does not need rebase anymore
2026-03-18 09:32:36 CFbot Patch needs rebase
2026-03-16 21:04:35 CFbot Patch does not need rebase anymore
2026-02-10 15:13:30 CFbot Patch needs rebase
2026-02-10 15:10:12 Daniil Davydov (dddaniil) New status: Needs review
2026-02-01 00:00:10 CFbot Moved from CF PG19-4 to CF PG19-Final
2026-01-28 20:58:21 Masahiko Sawada (masahikosawada) New status: Waiting on Author
2026-01-17 15:12:32 CFbot Patch does not need rebase anymore
2026-01-16 22:32:27 CFbot Patch needs rebase
2026-01-16 14:31:36 CFbot Patch does not need rebase anymore
2026-01-15 02:34:22 CFbot Patch needs rebase
2026-01-05 21:01:33 CFbot Patch does not need rebase anymore
2025-12-30 21:45:25 CFbot Patch needs rebase
2025-12-16 07:37:28 Daniil Davydov (dddaniil) Moved from CF PG19-3 to CF PG19-4
2025-11-20 20:12:30 CFbot Patch does not need rebase anymore
2025-11-20 18:43:23 CFbot Patch needs rebase
2025-10-28 13:17:10 Daniil Davydov (dddaniil) Moved from CF PG19-2 to CF PG19-3
2025-09-15 22:20:27 CFbot Patch does not need rebase anymore
2025-09-05 06:15:21 CFbot Patch needs rebase
2025-08-20 17:40:03 Masahiko Sawada (masahikosawada) Added masahikosawada as reviewer
2025-08-18 08:44:58 Daniil Davydov (dddaniil) Moved from CF PG19-1 to CF PG19-2
2025-06-03 13:23:19 Sami Imseih (simseih) Added simseih as reviewer
2025-05-16 08:58:23 Daniil Davydov (dddaniil) Changed name to Parallel processing of indexes in autovacuum
2025-05-16 07:42:43 Daniil Davydov (dddaniil) Attached mail thread CACG=ezZOrNsuLoETLD1gAswZMuH2nGGq7Ogcc0QOE5hhWaw=cw@mail.gmail.com
2025-05-16 07:42:42 Daniil Davydov (dddaniil) Created patch record
Edit