noisia v0.4.0 — release supporting the book PostgreSQL: разрушение и восстановление.
Two user-facing workloads changed since v0.3.0.
tempfiles
- Honest spill. The workload now produces temporary files through a genuine on-disk sort spill instead of artificially lowering
work_mem(#21). Temp-file pressure now reflects real query behaviour. --tempfiles.table-size(default64MB, base-2 MiB). Replaces the previously hardcoded dataset size (#22). A larger dataset makes eachORDER BY random()sort spill more temp bytes. Seeding runs before the query loop, so set--durationgenerously.
wait-xacts
- Blocked-waiters mechanism. Beyond holding locks, the workload now opens a controlled pool of blocked waiter connections, driving the cascade toward exhausting
max_connections(#23). - New flags:
--wait-xacts.waiters— cap of blocked waiter connections (default10;0= unlimited, not off).--wait-xacts.waiters-rate— waiter connections opened per second (default1).--wait-xacts.report-interval— self-report line cadence (default1s).
All new flags are backward-compatible; no breaking changes.
Full changelog: v0.3.0...v0.4.0