# The (very practical) Postgres Sharding Landscape

- Institution: CERN
- Speaker: Álvaro Hernández
- Year: 2026
- Language: English
- Source: [CERN](https://videos.cern.ch/record/3020778)
- Licence: [CERN](https://copyright.web.cern)
- Who can watch: Teens profiles and older (sources give no ratings; placed by Invisible Network from the source's own words)

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

0:10:39 Slide 9

0:11:14 Slide 10

0:11:28 Slide 11

0:12:54 Slide 12

0:15:34 Slide 13

0:16:31 Slide 14

0:16:49 Slide 15

0:17:31 Slide 16

0:18:02 Slide 17

0:19:36 Slide 18

0:20:04 Slide 19

0:20:21 Slide 20

0:20:31 Slide 21

0:20:43 Slide 22

0:21:13 Slide 23

0:21:49 Slide 24

0:22:10 Slide 25

0:22:25 Slide 26

0:23:11 Slide 27

0:23:25 Slide 28

0:23:39 Slide 29

0:24:37 Slide 30

0:26:49 Slide 31

0:27:47 Slide 32

0:28:12 Slide 33

0:28:45 Slide 34

0:29:03 Slide 35

0:31:14 Slide 36

0:31:34 Slide 37

0:32:12 Slide 38

0:32:40 Slide 39

0:33:25 Slide 40

0:35:07 Slide 41

0:35:40 Slide 42

0:36:04 Slide 43

0:36:29 Slide 44

0:37:09 Slide 45

0:37:50 Slide 46

0:38:45 Slide 47

0:39:32 Slide 48

0:39:49 Slide 49

0:44:19 Slide 50

0:45:12 Slide 51r>

## Lectures

1. [The (very practical) Postgres Sharding Landscape](https://invisiblenetwork.ai/learn/cern/3020778/bc97f9ed9c24), 46 min (CERN's player)