Why create Index blocks writes

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

. 21min 20sec

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

. 34min 8sec

Recommended Episodes

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.

. 1h 12min

2. Introduction to HTML

Start Here: Web Development

Please fill out this survey so I know what type of content YOU PERSONALLY WANT: ⁠https://beachangeagent.typeform.com/to/hQLXrjUS

. 29min 14sec

We Are Now Living In A Digital Police State - Find Out Why & How Today With David Icke

London Real

BROADCAST YOURSELF - 8 Week Course: https://londonreal.tv/by/ 2021 SUMMIT TICKETS: https://londonreal.tv/summit/ NEW MASTERCLASS EACH WEEK: http://londonreal.tv/masterclass-yt LATEST EPISODE: https://londonreal.link/latest WATCH ROSE/ICKE IV: https://freedomplatform.tv/icke

. 5min 7sec

21. Getting Into Web Dev & Learning How to Learn

Start Here: Web Development

Please fill out this survey so I know what type of content YOU PERSONALLY WANT: ⁠https://beachangeagent.typeform.com/to/hQLXrjUS

. 31min 59sec