postgresql
How Instagram scaled Postgres to 2 billion users without switching databases
Instagram hit the connection wall, the vertical scaling wall and the ID wall on Postgres, and cleared all three without switching databases. Here is what broke, in what order, plus the logical sharding and Snowflake ID patterns you can copy before your own database runs out of room.