Skip to content
Best Practices Working with Billion-row Tables in Databases episode artwork

Sep 14, 2020 14 min

Best Practices Working with Billion-row Tables in Databases

from The Backend Engineering Show with Hussein Nasser Hosted by Hussein Nasser

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

Episode details come from the podcast's RSS feed.

Embed this episode

Ready to play

Best Practices Working with Billion-row Tables in Databases

0:00 14:28

No transcript yet.

Requests help us decide what to transcribe next.

Frequently asked questions

How long is this episode of The Backend Engineering Show with Hussein Nasser?

This episode is 14 minutes long.

When was this The Backend Engineering Show with Hussein Nasser episode published?

This episode was published on September 14, 2020.

Can I download this The Backend Engineering Show with Hussein Nasser episode?

Yes. Use the download control on the episode player to save the publisher-provided media file.