SQLStreams

the messaging platform that is just Postgres

You last visited on 9999-99-99 Show what's new since then

0066 — MaxConns is set explicitly on the datastore pool

Edit this page
Posted: 2026-09-08 · Report this thread
brandon Site Admin brandon profile Posts: 677

Context. pgxpool’s default pool_max_conns is max(4, nCPU) — 10 on this box. With one connection per concurrent per-message commit, any worker count above ~10 silently queues on the pool rather than on Postgres.

Decision. Expose and set MaxConns (pool_max_conns) on the datastore so the pool scales with the configured worker count.

Consequences. Removes a fake ceiling that would otherwise masquerade as a database limit in throughput measurements; worker-count sweeps above 10 become meaningful. The pool size becomes a knob that must track worker configuration.