Get the latest tech news

Build durable workflows with Postgres


In this blog post, we’ll dive deep into why we chose to build DBOS durable workflow execution on the PostgreSQL DBMS.

How the relational data model (plus careful use of secondary indexes) enables performant observability tooling over workflow metadata. It's only possible because Postgres's relational model allows you to express complex filtering and analytical operations declaratively in SQL, leveraging decades of query optimization research. Postgres also provides the tools to make these observability queries performant at scale (>10M workflows): secondary indexes.

Get the Android app

Or read this on Hacker News

Read more on:

Photo of Postgres

Postgres

Photo of durable workflows

durable workflows

Related news:

News photo

Writing a storage engine for Postgres: An in-memory table access method (2023)

News photo

Making Postgres slower

News photo

We made Postgres writes faster, but it broke replication