Postgres can scale, despite controversy. Challenges include hardware needs and write capacity issues often due to lock contention or idle transactions. A community effort successfully implemented sharding to balance and increase write workloads across multiple databases, aligning with the engineering principle of solving problems fundamentally. The process involved complex steps like synchronizing data and rewriting codes. Ultimately, they created a scalable setup with 36 databases and a tool, PgDog, to automate future scaling. The project aims to demonstrate that Postgres can effectively scale as needed.
You Can Make Postgres Scale
