Microsoft released pg_durable, an open-source PostgreSQL extension that brings durable execution directly into the database. The extension eliminates the need for external orchestrators, message queues, and status tables by running long-running, fault-tolerant workflows inside PostgreSQL itself. The project reached 304 points on Hacker News on June 5, 2026.
Built on Rust and pgrx
pg_durable is built with pgrx and runs as a PostgreSQL background worker. The extension exposes a SQL DSL for defining function graphs and checkpoints each step of execution. Under the hood, it uses two Rust libraries: duroxide (a durable task framework) and duroxide-pg (a PostgreSQL-backed state provider). All state is stored in Postgres tables, leveraging ACID guarantees for reliability.
Designed for Complex Workflows in SQL
The extension targets teams that already manage state in PostgreSQL and want to eliminate the operational complexity of external orchestration systems. Use cases include:
- Vector embedding pipelines: chunk documents, call embedding APIs, and upsert results into pgvector
- Ingest pipelines: stage, deduplicate, transform, and publish large batches
- Scheduled maintenance: detect database bloat, send notifications, wait for approval, and execute corrective actions
- Fan-out aggregation: run independent queries in parallel and join results
- External API workflows: enrichment, classification, and webhook-style calls triggered from SQL
Part of a Broader Trend
pg_durable joins a growing category of database-native workflow systems. DBOS offers a commercial solution, while tensorzero/durable provides another open-source alternative. Armin Ronacher's Absurd Workflows takes a similar approach. The Postgres-native design appeals to teams that want to avoid the operational overhead of maintaining separate orchestration infrastructure while still achieving fault tolerance and long-running execution.
Key Takeaways
- Microsoft released pg_durable as an open-source PostgreSQL extension for durable execution workflows
- The extension runs as a background worker inside PostgreSQL, eliminating the need for external orchestrators or message queues
- Built with pgrx and Rust libraries duroxide and duroxide-pg, leveraging PostgreSQL's ACID guarantees for state management
- Supports use cases including vector embedding pipelines, ingest workflows, scheduled maintenance, and external API calls
- The project is currently in preview and available on GitHub