| From: | Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com> |
|---|---|
| To: | Nathan Bossart <nathandbossart(at)gmail(dot)com> |
| Cc: | Sami Imseih <samimseih(at)gmail(dot)com>, David Rowley <dgrowleyml(at)gmail(dot)com>, Jim Nasby <jnasby(at)upgrade(dot)com>, Greg Burd <greg(at)burd(dot)me>, 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-08-31 15:49:08 |
| Message-ID: | CALj2ACVVc+k2-qyCMJ2OJ464vrkxYX=_U0Zsv9LYPJrwgmsTOQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi,
On Mon, Aug 31, 2026 at 8:23 AM Nathan Bossart <nathandbossart(at)gmail(dot)com> wrote:
>
> Claude noticed a corner case that needs handling. In short, if the freeze
> score weights are high enough, the pow() calls can have the opposite of the
> intended effect, since the freeze scores may be less than 1. Patch
> attached.
Nice catch! Yes, it seems like an obvious issue and the fix looks good to me.
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.
--
Bharath Rupireddy
Amazon Web Services: https://aws.amazon.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2026-08-31 15:56:10 | Re: remove_useless_joins vs. bug #19560 |
| Previous Message | Melanie Plageman | 2026-08-31 15:46:40 | Re: WAL_LOG CREATE DATABASE strategy broken for non-standard page layouts |