Community roadmap to sharding - Alexander Korotkov: PGCon 2020
Channel: PGCon
Date: 2020-12-12

From https://www.pgcon.org/events/pgcon_2020/schedule/session/21-community-roadmap-to-sharding/

Sharding is one of most wanted PostgreSQL features. Vertical scalability is limited by hardware. Replication doesn't provide scalability in read-write performance and database size. Only sharding promises this.

However, such a brilliant feature is hard to implement. And here is the point where different community parties should work together. The PostgreSQL community has done a great work on foreign data wrappers and continues improving them. Postgres Pro has experience in distributed transactions, snapshots and query planning/execution.

In this talk we will cover existing advances in sharding and present a roadmap of transforming them into a comprehensive sharding solution suitable for the main use cases.