| From: | shihao zhong <zhong950419(at)gmail(dot)com> |
|---|---|
| To: | pgsql-hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | [PATCH] Fix autovacuum freeze bug where weight can lower a table's freeze score |
| Date: | 2026-09-01 03:57:02 |
| Message-ID: | CAGRkXqSJ5j24kLQ83gVtYXE5-Oa4jxxAYKFJU5=EfG2yGAXKqA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi hackers,
In the autovacuum freeze scores added by d7965d65fc5, raising a freeze
weight can make a table's score smaller instead of larger. When a table
gets old, its score is raised to a power to grow fast, but a larger weight
makes this start while the score is still below one, where a power makes it
smaller. So a bigger weight can push a table near wraparound down the list.
The safety net still works; only the order changes.
The attached patch raises the score to a power only when that makes it
bigger, with a test. New in v19, so no backport needed.
Thanks,
Shihao
| Attachment | Content-Type | Size |
|---|---|---|
| 0001-Don-t-let-a-larger-autovacuum-freeze-weight-lower-th.patch | application/octet-stream | 6.1 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Fujii Masao | 2026-09-01 03:57:54 | Re: doc: Reformat SELECT queries using GRAPH_TABLE |
| Previous Message | Noah Misch | 2026-09-01 03:53:11 | Re: pg_*_advice: tsv load failure, etc. |