#Dbos

Postgres SELECT DISTINCT performs surprisingly poorly. We explain why and how we mitigated it.

How we optimized Postgres LISTEN/NOTIFY-backed data streams at scale, achieving 60K writes per second with millisecond latency.

When workflow metadata and application data live in the same Postgres database, they can be updated in the same database transaction, which simplifies tough problems like workflow task idempotency and atomicity.