SQLStreams

the messaging platform that is just Postgres

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

0392 — cursor claimed advances via GREATEST so a group running both paths cannot regress its frontier

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

Context. With LIFECYCLE groups now holding cursor rows, a group mistakenly running both the cursor-claim path and the FanOut path would have two writers to the same claimed column, and a plain assignment from the slower path could move the frontier backward into territory the other path already claimed — reopening ranges for overlapping delivery.

Decision. claimed advances via GREATEST, so no write can regress it below its current value regardless of which path issued the write.

Consequences. Misconfiguration (both paths active on one group) degrades to redundant work instead of double-delivery overlap. The invariant is monotonic: the claim frontier only moves forward.