Behind the notes
About PostgreSQL in Production
For the work between finding a problem and understanding it.
I’m Niko Minadze, and PostgreSQL in Production is about making sense of PostgreSQL in real applications. It’s for the people writing queries, investigating unexpected behavior, and keeping database-backed services running.
You’ll find practical articles on SQL and schema design, indexes and query plans, transactions and locks, migrations, vacuum, backups, replication, and other production concerns. Each piece starts with a concrete workload, symptom, or decision, then looks at the PostgreSQL behavior behind it with a small SQL example and a way to check the result.
The aim is to make tradeoffs clear, including correctness, write overhead, and recovery where they matter. Examples stay portable where possible, with version details and provider restrictions called out when relevant.