| From: | Nathan Bossart <nathandbossart(at)gmail(dot)com> |
|---|---|
| To: | Bharath Rupireddy <bharath(dot)rupireddyforpostgres(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 16:47:56 |
| Message-ID: | apWwPMCotJ7OUOWb@nathan |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Mon, Aug 31, 2026 at 08:49:08AM -0700, Bharath Rupireddy wrote:
> 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.
Thanks for looking.
> 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.
Seems worth a try.
--
nathan
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bharath Rupireddy | 2026-08-31 17:01:27 | Re: REPACK: warn about skipping foreign partitions |
| Previous Message | Bruce Momjian | 2026-08-31 16:47:09 | Re: scary patch contest |