SQLStreams

the messaging platform that is just Postgres

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

0004 — Batch limit pinned to 1

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

Context. Claiming several messages in one transaction ties their fates together: one poison message that fails or hangs poisons the whole batch, holding or rolling back messages that would have succeeded.

Decision. The claim batch limit is pinned to 1 — each transaction claims and processes a single message.

Consequences. Batch poisoning is impossible by construction. The cost is one claim round-trip per message, an accepted throughput ceiling at this scale.