Why Database Sharding Still Works in 2026 cover art

Why Database Sharding Still Works in 2026

Why Database Sharding Still Works in 2026

Listen for free

View show details
In this episode of Database Tech with Fexingo, Lucas and Luna dive into the practical realities of database sharding in 2026. They use the example of a fast-growing e-commerce platform that split its order history across ten shards only to hit a cross-shard join nightmare. Lucas explains the difference between horizontal sharding and vertical partitioning, and why choosing the wrong shard key (user ID vs. order date) can destroy query performance. They discuss trade-offs between application-managed sharding and newer distributed SQL databases like CockroachDB and YugabyteDB. Luna brings up the hidden cost of resharding when data distribution skews. Specific benchmarks: how one mid-size fintech reduced p99 query latency from 600ms to 40ms after sharding by customer region. The episode also tackles the myth that sharding is obsolete thanks to NewSQL — and why smart engineers still reach for it when a single Postgres instance hits 4TB. No fluff, just practical data architecture. #DatabaseSharding #HorizontalPartitioning #ShardKey #CrossShardJoins #DistributedSQL #CockroachDB #YugabyteDB #Postgres #QueryPerformance #Latency #Resharding #DataSkew #NewSQL #TechPodcast #DatabaseTech #FexingoBusiness #BusinessPodcast #DataArchitecture Keep every episode free: buymeacoffee.com/fexingo
adbl_web_anon_alc_button_suppression_t1
No reviews yet