Skip to content
Aniefiok Akpan

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

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

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. 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