Report oldest xmin source when autovacuum cannot remove tuples

Edit
ID 6188
Title Report oldest xmin source when autovacuum cannot remove tuples
CI (CFBot) Needs rebase! Needs rebase since 2 months. Failing since 2 months.
Additional links previous successfully applied patch (outdated):
Stats (from CFBot) Unknown
Tags Monitoring
Created 2025-10-31 06:33:20
Last modified 2026-10-01 12:38:06 (1 hour ago)
Latest email 2026-10-01 12:20:14 (1 hour ago)
Status
PG20-3 (2026-11-01 – 2026-11-30): Needs review
PG20-2 (2026-09-01 – 2026-09-30): Moved to different CF
PG20-1 (2026-07-01 – 2026-07-31): Moved to different CF
PG19-Final (2026-03-01 – 2026-04-09): Moved to different CF
PG19-4 (2026-01-01 – 2026-01-31): Moved to different CF
PG19-3 (2025-11-01 – 2025-11-30): Moved to different CF
Target version 20
Authors Shinya Kato (shinyakato)
Reviewers Fujii Masao (masaofujii), Bharath Rupireddy (bharathrupireddy), Sami Imseih (simseih), Scott Ray (scottray) Become reviewer
Committer
Links
Emails
Report oldest xmin source when autovacuum cannot remove tuples
First at 2025-10-31 06:31:40 by Shinya Kato <shinya11.kato at gmail.com>
Latest at 2026-10-01 12:20:14 by Shinya Kato <shinya11.kato at gmail.com>
Latest attachment (v10-0001-Report-what-held-back-the-removable-cutoff-in-VA.patch) at 2026-10-01 12:20:14 from Shinya Kato <shinya11.kato at gmail.com>
    Attachment (v10-0001-Report-what-held-back-the-removable-cutoff-in-VA.patch) at 2026-10-01 12:20:14 from Shinya Kato <shinya11.kato at gmail.com> (Patch: No)
    Attachment (v1-0001-Report-what-holds-back-the-oldest-xmin-horizon-du.patch) at 2026-07-14 19:38:25 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v9-0001-Add-infrastructure-to-identify-what-holds-back-th.patch) at 2026-07-07 16:34:06 from Shinya Kato <shinya11.kato at gmail.com> (Patch: Yes)
    Attachment (v8-0001-Add-infrastructure-to-identify-what-holds-back-th.patch) at 2026-07-07 15:44:29 from Shinya Kato <shinya11.kato at gmail.com> (Patch: Yes)
    Attachment (v7-0001-Add-infrastructure-to-identify-what-holds-back-th.patch) at 2026-06-27 08:08:02 from Shinya Kato <shinya11.kato at gmail.com> (Patch: Yes)
    Attachment (v6-0001-Add-infrastructure-to-identify-what-holds-back-th.patch) at 2026-06-26 09:07:48 from Shinya Kato <shinya11.kato at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Refactor-GetXidHorizonBlockers-around-a-new-GetXidHo.patch) at 2026-06-06 18:40:31 from Scott Ray <scott at scottray.io> (Patch: Yes)
    Attachment (v5-0001-Report-oldest-xmin-blocker-when-VACUUM-cannot-rem.patch) at 2026-05-23 06:00:33 from Shinya Kato <shinya11.kato at gmail.com> (Patch: Yes)
    Attachment (v4-0001-Report-oldest-xmin-blocker-when-VACUUM-cannot-rem.patch) at 2026-05-23 05:22:48 from Shinya Kato <shinya11.kato at gmail.com> (Patch: Yes)
    Attachment (v3-0001-Report-oldest-xmin-blocker-when-VACUUM-cannot-rem.patch) at 2026-05-22 13:05:31 from Shinya Kato <shinya11.kato at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Report-oldest-xmin-blocker-when-VACUUM-cannot-rem.patch) at 2026-02-05 04:39:27 from Shinya Kato <shinya11.kato at gmail.com> (Patch: Yes)
    Attachment (0001-sketch-of-cutoff-reasons.txt) at 2025-11-15 00:25:36 from Sami Imseih <samimseih at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Report-oldest-xmin-source-when-autovacuum-cannot-.patch) at 2025-10-31 06:31:40 from Shinya Kato <shinya11.kato at gmail.com> (Patch: Yes)
History
When Who What
2026-10-01 12:38:06 Shinya Kato (shinyakato) Moved from CF PG20-2 to CF PG20-3
2026-09-01 02:39:12 Scott Ray (scottray) Added scottray as reviewer
2026-08-05 00:00:19 Bharath Rupireddy (bharathrupireddy) Added bharathrupireddy as reviewer
2026-08-01 00:00:09 CFbot Moved from CF PG20-1 to CF PG20-2
2026-07-29 20:43:31 CFbot Patch needs rebase
2026-07-07 17:10:36 CFbot Patch does not need rebase anymore
2026-07-05 16:30:30 CFbot Patch needs rebase
2026-06-27 08:11:25 Shinya Kato (shinyakato) New status: Needs review
2026-06-26 09:39:32 CFbot Patch does not need rebase anymore
2026-06-06 19:03:27 CFbot Patch needs rebase
2026-06-02 11:27:40 Shinya Kato (shinyakato) Changed targetversion to 20
2026-05-28 05:35:27 Shinya Kato (shinyakato) New status: Waiting on Author
2026-05-22 13:35:31 CFbot Patch does not need rebase anymore
2026-05-22 13:16:24 Shinya Kato (shinyakato) New status: Needs review
2026-04-14 22:23:16 Shinya Kato (shinyakato) New status: Waiting on Author
2026-04-10 00:00:05 CFbot Moved from CF PG19-Final to CF PG20-1
2026-03-26 09:00:27 CFbot Patch needs rebase
2026-02-05 06:47:33 CFbot Patch does not need rebase anymore
2026-02-05 05:24:38 Shinya Kato (shinyakato) New status: Needs review
2026-02-01 07:04:34 Shinya Kato (shinyakato) Moved from CF PG19-4 to CF PG19-Final
2026-01-08 11:58:22 CFbot Patch needs rebase
2025-12-01 03:39:14 Shinya Kato (shinyakato) Moved from CF PG19-3 to CF PG19-4
2025-11-14 01:46:18 Sami Imseih (simseih) Added simseih as reviewer
2025-11-04 10:36:04 Fujii Masao (masaofujii) Added masaofujii as reviewer
2025-11-04 03:43:02 Shinya Kato (shinyakato) New status: Waiting on Author
2025-10-31 06:33:20 Shinya Kato (shinyakato) Attached mail thread CAOzEurSgy-gDtwFmEbj5+R9PL0_G3qYB6nnzJtNStyuf87VSVg@mail.gmail.com
2025-10-31 06:33:20 Shinya Kato (shinyakato) Created patch record
Edit