Speaker
Álvaro Hernández
Description
Sharding enables horizontal scaling of Postgres, by logically splitting your database into several subsets ("shards"). Each shard will be a primary or, for high availability purposes, a primary-replica cluster. This allows you to scale writes horizontally, allowing Postgres to reach database sizes of multiple terabytes or even petabytes.
Sharding solutions for Postgres exist in multiple forms, such as embedded into Postgres as an extension, using native Postgres techniques and as external components, including Citus, Apache ShardingSphere, PgDog, native partitions with FDW, and others. This talk will:
- Analyze the evolving landscape of sharding solutions for Postgres.
- Offer advice and recommendations on which one to select.
- Provide open source code for simple demos so you can quickly evaluate them in your own environment.
- Present a real-world case study: planning the migration of a 1PB+ workload to sharded Postgres at a major US telco.
If demo Gods will allow, demos of sharding Postgres will be performed live.
