| Bonus Resources.txt | 102.4 B | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| ~Get Your Files Here ! | |||
| 1 - Start here what sharding is, and how companies run a database | |||
| 1. Code for this course (GitHub).url | 102.4 B | ||
| 1. What sharding is, and what we will build.mp4 | 52.9 MB | ||
| 1. postgres-sharding-slides-full.pdf | 11.7 MB | ||
| 1. slides-01.pdf | 838.2 KB | ||
| 2 - Build the lab Docker, PostgreSQL and the first tables | |||
| 3 - One database measure it, climb the ladder, choose the key | |||
| 4 - Four shards build the router, then fix what breaks | |||
| 10. The dashboard that asks every shard.mp4 | 51.8 MB | ||
| 10. slides-10.pdf | 648.4 KB | ||
| 11. The 9 pm flash sale.mp4 | 98 MB | ||
| 11. slides-11.pdf | 725 KB | ||
| 12. Too many connections, and the pool that fixes it.mp4 | 59.7 MB | ||
| 12. slides-12.pdf | 1.1 MB | ||
| 13. A fifth shard the ring road and buckets.mp4 | 81.3 MB | ||
| 13. slides-13.pdf | 1.5 MB | ||
| 5 - The hard parts, and the enterprise way with Citus | |||
| 14. What sharding makes hard.mp4 | 10.2 MB | ||
| 14. slides-14.pdf | 508.9 KB | ||
| 15. The enterprise way Citus, and how others do it.mp4 | 111 MB | ||
| 15. slides-15.pdf | 1.4 MB | ||
| 6 - Should you shard | |||
| 16. Should you shard The checklist, the interview answer, clean-up.mp4 | 19.3 MB | ||
| 16. slides-16.pdf | 643.9 KB | ||
| 9. Four ways to split the data, then four shards and a router.mp4 | 183.3 MB | ||
| 9. slides-09.pdf | 1.6 MB | ||
| 6. Measure it orders per second, p95, the slow second.mp4 | 200.1 MB | ||
| 6. slides-06.pdf | 1 MB | ||
| 7. Climb the ladder a replica, and partitioning by month.mp4 | 99.7 MB | ||
| 7. slides-07.pdf | 921.8 KB | ||
| 8. Choose the shard key from the queries.mp4 | 26.2 MB | ||
| 8. slides-08.pdf | 567.1 KB | ||
| 3. Code for this course (GitHub).url | 102.4 B | ||
| 3. Meet KiranaLoop, and get your laptop ready.mp4 | 33.1 MB | ||
| 3. slides-03.pdf | 696.1 KB | ||
| 4. Is PostgreSQL running psql and pgAdmin.mp4 | 18.8 MB | ||
| 4. slides-04.pdf | 663.4 KB | ||
| 5. The app container and the first tables.mp4 | 105.2 MB | ||
| 5. slides-05.pdf | 590.9 KB | ||
| 2. How enterprises run a database.mp4 | 21 MB | ||
| 2. slides-02.pdf | 756.3 KB |
Postgres Sharding: Complete Hands-On with Docker and Python
https://WebToolTip.com
Published 10/2026
Created by Roni Das
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz, 2 Ch
Level: Intermediate | Genre: eLearning | Language: English | Duration: 16 Lectures ( 2h 34m ) | Size: 1.2 GB
Build an orders database, load it until it breaks, shard it yourself, add PgBouncer and Citus, and measure every step
What you'll learn
⚡ Decide when a slow PostgreSQL database needs sharding, and when an index, a cache, a replica or partitioning is enough
⚡ Choose a shard key from real queries, and measure how evenly it spreads the data
⚡ Write a shard router in Python and move a million customers and 8.5 million orders into four shards
⚡ Load test a database with 64 concurrent checkout servers and read throughput and p95 latency correctly
⚡ Fix the classic sharding problems: fan-out queries, hot rows, connection limits and adding a shard
⚡ Put PgBouncer in front of each shard in transaction mode, and know what it costs
⚡ Use consistent hashing and logical buckets so adding a shard moves about a fifth of the data, not four fifths
⚡ Shard PostgreSQL with Citus: distributed tables, co-location, Task Count and live rebalancing
⚡ Answer "how would you shard an orders database?" in a system design interview, with real numbers
Requirements
❗ A laptop with Docker Desktop installed and running (Mac, or Windows with WSL 2), about 8 GB of memory for Docker and 10 GB of free disk
❗ VS Code, or any code editor you like
❗ Basic comfort with a terminal. You do not need to install Python: every file runs inside a container
❗ Some SQL helps, but every statement is explained as we write it
All Comments