lesovsky/noisia v0.4.0

on GitHub

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 (default 64MB, base-2 MiB). Replaces the previously hardcoded dataset size (#22). A larger dataset makes each ORDER BY random() sort spill more temp bytes. Seeding runs before the query loop, so set --duration generously.

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 (default 10; 0 = unlimited, not off).
  • --wait-xacts.waiters-rate — waiter connections opened per second (default 1).
  • --wait-xacts.report-interval — self-report line cadence (default 1s).

All new flags are backward-compatible; no breaking changes.

Full changelog: v0.3.0...v0.4.0