7.8. WITH Queries (Common Table Expressions) # 7.8.1. SELECT in WITH 7.8.2. Recursive Queries 7.8.3. Common Table Expression Materialization 7.8.4. Data-Modifying …| PostgreSQL Documentation
We're Sequin, an open source message stream like Kafka, but built on Postgres. Stable, sequential ordering is a very useful thing to have when building a streaming system. But Postgres' behavior here can be surprising! We go down the rabbit hole below. An under-appreciated fact is that while MVCC (multi-version| Sequin blog