When to switch databases: Uber versus Instagram 1 question in 2 chapters

  1. 01Database choice and migration
  2. 02Sources

Database choice and migration

  • 1.1 When is switching databases the right call? Compare Uber and Instagram. Hard 7 min

    I'd switch databases only when a measured limit is built into the engine's design and can't be fixed by tuning, a newer version, or sharding. Uber left Postgres in 2016 over write amplification and replication pain, mostly on version 9.2. Instagram kept Postgres and scaled it with thousands of logical shards. So first I'd check HOT updates, logical replication and sharding, then price the migration.

    Read the full answer

Sources