Definition
A powerful open-source relational (SQL) database with strong ACID guarantees.
How it works
Great default: transactions, joins, indexes, JSON. Scales reads with replicas; very large writes/size eventually need sharding.
Common questions
What is Postgres?
A powerful open-source relational (SQL) database with strong ACID guarantees.
How does Postgres work?
Great default: transactions, joins, indexes, JSON. Scales reads with replicas; very large writes/size eventually need sharding.
What is Postgres used for in system design?
Great default: transactions, joins, indexes, JSON. Scales reads with replicas; very large writes/size eventually need sharding.
Part of Glossary on SystemLore — system design explained with 148 deep topics, interactive diagrams, and a build-it-yourself game. Build this one →