| From: | Nathan Bossart <nathandbossart(at)gmail(dot)com> |
|---|---|
| To: | Sami Imseih <samimseih(at)gmail(dot)com> |
| Cc: | David Rowley <dgrowleyml(at)gmail(dot)com>, Bharath Rupireddy <bharath(dot)rupireddyforpostgres(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:23:26 |
| Message-ID: | apWcbq91BAfhmsKU@nathan |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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.
--
nathan
| Attachment | Content-Type | Size |
|---|---|---|
| v1-0001-Fix-backwards-scaling-of-autovacuum-freeze-scores.patch | text/plain | 2.6 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bertrand Drouvot | 2026-08-31 15:28:09 | Re: Offline data checksum changes can cause incorrect checksum state on standbys |
| Previous Message | Nitin Jadhav | 2026-08-31 15:19:42 | Re: aio: Async fsyncs for crash recovery and checkpointer |