Conference Schedule - PGCon 2020

Community roadmap to sharding

Date: 2020-05-27
Time: 10:00 - 10:45
Room: Stream 2
Level: Intermediate
Feedback: Leave feedback

This talk appears on stream2

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.

Speaker

Alexander Korotkov