| From: | shihao zhong <zhong950419(at)gmail(dot)com> |
|---|---|
| To: | Nathan Bossart <nathandbossart(at)gmail(dot)com> |
| Cc: | Greg Burd <greg(at)burd(dot)me>, Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>, Sami Imseih <samimseih(at)gmail(dot)com>, David Rowley <dgrowleyml(at)gmail(dot)com>, Jim Nasby <jnasby(at)upgrade(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, Robert Treat <rob(at)xzilla(dot)net>, Jeremy Schneider <schneider(at)ardentperf(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: another autovacuum scheduling thread |
| Date: | 2026-09-02 01:19:23 |
| Message-ID: | CAGRkXqSnGfeZNB-k4bwg=j88r83yz=AJ0aKAGdYbzczMeDwexA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi,
Thanks for committing the fix, Nathan.
> Can we add some tests for HEAD for the autovacuum scoring feature? I
> understand it's a bit hard to get the tests to run deterministically,
> but if it's worth it, I can give it a try.
I already had one written, so let me share it to save you the effort.
To keep it deterministic and fast, it fakes an old relfrozenxid and
relminmxid with a catalog UPDATE instead of consuming transactions.
Patch attached, on top of your commit.
Thanks,
Shihao
| Attachment | Content-Type | Size |
|---|---|---|
| 0001-Add-a-test-for-autovacuum-freeze-score-scaling.patch | application/octet-stream | 4.7 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | shihao zhong | 2026-09-02 01:20:24 | Re: [PATCH] Fix autovacuum freeze bug where weight can lower a table's freeze score |
| Previous Message | Fujii Masao | 2026-09-02 01:14:32 | Re: [PATCH] Fix pg_dump emitting OVERRIDING SYSTEM VALUE for tables with dropped identity columns |