About
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.
0:00:00 Slide 1
0:00:40 Slide 2
0:02:03 Slide 3
0:03:10 Slide 4
0:04:06 Slide 5
0:07:40 Slide 6
0:09:02 Slide 7
0:10:07 Slide 8
The talk
Credits and licence
- Institution
- CERN
- Speaker
- Álvaro Hernández
- Year
- 2026
- Language
- English
- Source
- CERN
- Licence
- CERN, as CERN states it. CERN's terms
- Attribution
- © CERN. CERN provides its audiovisual media free of charge for educational and informational use, credited to CERN; this lecture is shown in CERN's own player.
- Who can watch
- CERN gives no rating. Invisible Network shows it to Teens profiles and older, judged from what the source says about it. How courses are placed