🐘🌪️ Do you know your default autovacuum thresholds?

❄️🔥 How do they depend on the hot/cold data split?

The scale factor is calculated against the total table size — not your active working set. Cold historical data inflates your thresholds, leaving hot rows with stale statistics and growing bloat.

👇🏼 I ran a small test to visualize the staleness accumulation over time: https://dev.to/franckpachot/the-autovacuum-scale-factor-problem-at-scale-know-your-defaults-5a9o