Database Partitioning Explained

Database Partitioning Explained

Up next

How a query optimization gave birth to infinite scroll

The infinite scroll in social media as we know it today is despised by all. But it always start as a bad idea. It originated as a result of UI change to relief the backend database from inefficient queries. I explore this in this episode of the backend engineering. 0:00 Intro1:00 ...  Show more

Postgres is half as fast in Linux 7.0

An aws engineer discovered a 50% regression in postgres throughput while testing the new Linux 7.0 kernel. The cause turns out to be massive TLB and page faults exacerbated by Postgres process-based design. In this backend engineering show episode I dive deep into how this was di ...  Show more

Recommended Episodes

#1028: Databases
Magic: The Gathering Drive to Work Podcast

In this podcast, I talk about one of the most important tools we use for Magic design—databases. I walk through the history of our databases and explain how we use them.

 

166: Speedy Database Queries with Lukas Fittl
Programming Throwdown

pganalyze: - Weekly series "5mins of Postgres": - How Postgres chooses which index to use: - CMU databases courses: - Postgres community: As well as social links: - Mastodon: - Twitter/X: @pganalyze, @LukasFittl - GitHub: @pganalyze, @lfittl - LinkedIn. 

Episode 1 - An Introduction
The History of Byzantium

I explain the idea behind the podcast and how I intend to proceed. I also talk about how often I will be able to create episodes. Hosted on Acast. See acast.com/privacy for more information. 

Next Level Entrepreneurs Secret Weapon - Analyzing The RIGHT Data
Valuetainment

In this video, Patrick Bet-David talks about the different ways to understand and analyze data.

Watch this video here: https://youtu.be/ahiH4zKTfRw

Suggested video: How to Strategize as an Entrepreneur: <a href="https://www.youtube.com/watch?v=2jG6 ...

  Show more