Skip to content

Indexes I added, then removed

Three index changes that looked obvious in review and cost more than they saved once real traffic arrived.

, 6 min read

Filed under

  • Databases
  • PostgreSQL

Related

  1. System design, , 9 min read

    Idempotent consumers, without the ceremony

    What actually happens when the same message arrives twice, and the smallest set of changes that makes a consumer safe to retry.

    • Messaging
    • Kafka
    • PostgreSQL
  2. Architecture Lab, , 16 min read

    Designing a URL shortener

    The classic interview system, built small and measured: where the reads go, what the cache is for, and the one decision that made everything else easy.

    • Caching
    • Redis
    • PostgreSQL
    • +1 more
  3. System design, , 8 min read

    Sharding vs partitioning

    Two words used interchangeably in meetings, and the operational difference that makes them not the same thing at all.

    • Databases
    • Distributed systems

Next

Have a system worth arguing about?

If this note raised a question, or you would have designed it differently, I would like to hear it.

Start a conversation