logo
episode-header-image
Sep 2020
14m 28s

Best Practices Working with Billion-row ...

Hussein Nasser
About this episode

In this video, I discuss 3 methods to work with tables of billion rows. This discussion is inspired by a comment on my YouTube video on Twitter System Design right here https://www.youtube.com/watch?v=gfq-LG9ZJQA&lc=UgyYbm5889dW0XtKhsV4AaABAg

Chapters

Intro 0:00

1. Brute Force Distributed Processing 2:30

2. Working with a Subset of table 3:35

2.1 Indexing 3:55

2.2 Partitioning 5:30

2.3 Sharding 7:30

3. Avoid it all together (reshuffle the whole design) 9:10

Summary 11:30

--- Support this podcast: https://anchor.fm/hnasr/support
Up next
Jun 13
kTLS - Kernel level TLS
Fundamentals of Operating Systems Course https://oscourse.winktls is brilliant.TLS encryption/decryption often happens in userland. While TCP lives in the kernel. With ktls, userland can hand the keys to the kernel and the kernel does crypto. When calling write, the kernel encryp ... Show More
22m 55s
May 9
The beauty of the CPU
If you are bored of contemporary topics of AI and need a breather, I invite you to join me to explore a mundane, fundamental and earthy topic.The CPU.A reading of my substack article https://hnasr.substack.com/p/the-beauty-of-the-cpu 
9m 38s
Apr 18
Sequential Scans in Postgres just got faster
This new PostgreSQL 17 feature is game changer. They know can combine IOs when performing sequential scan. Grab my database coursehttps://courses.husseinnasser.com 
27m 36s
Recommended Episodes
Feb 2023
Frontend Feud: CSS Podcast vs @keyframers
Una & Adam from The CSS Podcast defend their Frontend Feud title against challengers David & Shaw from the keyframers. Let’s get it on! Leave us a comment Changelog++ members save 6 minutes on this episode because they made the ads disappear. Join today! Sponsors: Sentry – Sessio ... Show More
51m 10s
Feb 2023
Frontend Feud: CSS Podcast vs @keyframers (JS Party #264)
Una & Adam from The CSS Podcast defend their Frontend Feud title against challengers David & Shaw from the keyframers. Let’s get it on! Leave us a comment Changelog++ members save 6 minutes on this episode because they made the ads disappear. Join today! Sponsors: Sentry – Sessio ... Show More
51m 10s
Jun 2023
"Mat Depends"
Mat Ryer is back and he’s brought with him 10 tips to be a 10x developer (like he is). After that, we try a new segment we’re calling “Tool Time” (and try out a few jingles for it along the way). Finally, it’s time to review our previous unpopular opinions and put some new ones i ... Show More
1h 40m
Mar 2023
50: FREE 5-Step SQL Course & Project
📤 In this episode, Avery’s going to walk you through how you can teach yourself SQL for FREE with this awesome 5-step course. 🌟 Join the data project club! “25OFF” to get 25% off (first 50 members). 📊 Come to my next free “How to Land Your First Data Job” training🏫 Check out ... Show More
9m 55s
May 2023
Blockchain Scalability w/ Cartesi
Omran is a tech-savvy with a background in software architecture for more than 15 years, having worked in big companies such as Google and Intel. Max, on the other hand, even without a tech background, has always been curious about innovation and technology, using business models ... Show More
1h 3m
Jun 2023
Ep. 251: The Efficiency Trap
Productivity YouTube is filled with breathless videos about optimizing systems and squeezing every ounce of speed out of your common habits. But does all of this efficiency really end up improving the quality of the most important things you produce? In this episode, Cal takes a ... Show More
1h 10m
Aug 2022
Tech job interview support group
Struggling through the tech job interview process? We feel you! On this episode, Amal, Nick & Amelia get together to discuss the various ways the interview process disappoints, share their own interview stories, and suggest ways we can improve the process for everyone. Discuss on ... Show More
1h 4m
Apr 2024
752: React vs Vue vs Angular with Corbin Crutchley
Which framework is best? Join Scott and Wes as they chat with Corbin Crutchley, author of the “Framework Field Guide”, diving into the world of frameworks, metaframeworks, and tips to stay up-to-date on the latest trends in web development. Show Notes 00:00 Welcome to Syntax! 00: ... Show More
57m 37s
Dec 2019
How to Get Rich: Every Episode
This giant episode collects every interview I’ve done on “How to Get Rich.” It includes 10 minutes of unreleased material—at the end—on “Finding Time to Invest in Yourself.” Transcript: http://nav.al/rich Seek Wealth, Not Money or Status 1:30 Make Abundance for the World 6:40 Fre ... Show More
3h 35m
Jun 2019
How to Get Rich: Every Episode
This giant episode collects every interview I’ve done on “How to Get Rich.” It includes 10 minutes of unreleased material—at the end—on “Finding Time to Invest in Yourself.” Transcript: http://nav.al/rich Seek Wealth, Not Money or Status 1:30 Make Abundance for the World 6:40 Fre ... Show More
3h 35m