PGCon2019 - 3.4

PGCon 2019
The PostgreSQL Conference

Bruce Momjian
Day Talks - Day 2 - 2019-05-31
Room DMS 1160
Start time 11:00
Duration 00:45
ID 1357
Event type Lecture
Track Scaling Out
Language used for presentation English

The Future of Postgres Sharding

Database sharding involves spreading database contents across multiple servers, with each server holding only part of the database. While it is possible to vertically scale Postgres, and to scale read-only workloads across multiple servers, only sharding allows multi-server read-write scaling.

This presentation will cover the advantages of sharding and future Postgres sharding implementation requirements, including foreign data wrapper enhancements, parallelism, and global snapshot and transaction control. This is a followup to my Postgres Scaling Opportunities presentation.