Reddit built a scalable metadata store to handle over 100k reads per second, choosing Postgres over Cassandra due to manageability and flexibility challenges with the latter. They implemented dual writes, backfill data, dual reads, and other strategies for data migration. To achieve high performance, they utilized table partitioning and denormalization. Reddit's current setup on AWS Aurora Postgres delivers low latency without the need for a read-through cache.
Sort: