The correct answer is “Postgres would handle it, but if it needed to scale even higher, I’d…”
The point of a system design interview is to have a discussion that examines possibilities and tradeoffs.
The point of a system design interview is to have a discussion that examines possibilities and tradeoffs.
Then, there are hiring managers that suck and you might be discarded because you didn't follow the script. Sure, but that's a bullet you dodged.