Skip to content
Preptima
hardDesignScenarioSeniorStaffLead

You are asked to design something distributed and your honest answer is one Postgres box. When is that the strongest answer in the room, and when does it end the interview?

One PostgreSQL primary with a replica and tested backups is the strongest answer when a capacity estimate built from the prompt fits it with headroom and the core invariants need transactions. It ends the interview when the prompt rules it out, or when you use it to decline the distributed design you were asked for.

5 min readUpdated 2026-10-09

Answer

Short answer

One box is often the right design. A single PostgreSQL primary, with a streaming replica, tested backups and a failover plan, is the strongest answer when a capacity estimate built from the stated requirements fits it with room to spare and the system's invariants need real transactions. It ends the interview in two cases. The prompt itself rules it out, for example with writes that must survive the loss of a region. Or you use it to refuse the exercise, leaving the interviewer with nothing to grade.

Was this answer helpful?

Likely follow-ups

  • Restoring the database would take four hours and the business accepts one. What do you change before you change the database?
  • Writes must continue in Sydney while the London region is down. What does that requirement cost that one primary never charged you?
  • Which invariant would you lose first if you sharded by user rather than by tenant, and how would you notice?
  • What would you measure in the first month of production to learn how much headroom the single primary really has?

Related questions

Masterclass guide

Related Topics