How Reddit built a Metadata Store that Handles 100k Reads per Second

Reddit developed a media metadata store that handles 100k reads per second to accommodate their rapidly growing user base. They opted for Sharded Postgres over Cassandra due to easier management and fewer denormalization issues. The migration involved dual writes, backfill data, and dual reads. Their scaling strategies include table partitioning using the pg_partman extension and data denormalization to optimize query efficiency.