PostgreSQLasdefault:whenweacceptadifferentprimarystore

Across recent programmes, most systems we operate use Postgres as the system of record. Exceptions were driven by measurable workload properties (very large time series, graph-shaped queries, or retention-bound append-only logs), not by stack fashion.

Postgres reduces early risk because JSONB, logical replication, extensions, and pgvector cover many adjacent needs without a second operational datastore.

We adopt specialised databases when measurements on realistic data and access patterns require it. That bar has avoided a number of high-operations-cost migrations for clients.