Index Fill Factor | The Backend Engineering Show

episode

The Backend Engineering Show with Hussein Nasser not yet transcribed

▲ 0

Transcript

This episode hasn't been transcribed yet Upvotes decide what gets transcribed next — 0 so far. Sign in to upvote

Related

recent transcribed audio

NPR News: 09-29-2026 7AM EDT 4 min · 29 Sep 2026 · NPR News Now

7AM ET 09/29/2026 Newscast 3 min · 29 Sep 2026 · Fox News Hourly Update

Most replayed moment: The hidden dangers of hearing loss | Prof. Marcelo Rivolta 8 min · 29 Sep 2026 · ZOE Science & Nutrition

Overmedicated To Death: Former FDA Officer on Presley Gerber & The Psychiatric Crisis in America w/ Dr. Mary Talley Bowden, Dr. Josef Witt-Doerring & Ronald Owens Jr. – Ask Dr. Drew – Ep 670 1h 19m · 29 Sep 2026 · Ask Dr. Drew

Federal boost for Navitas 6 min · 29 Sep 2026 · Wall Street Breakfast

SpaceX Starship Finally Reached Orbit & Why Dudes Are Becoming Cat Dads 29 min · 29 Sep 2026 · Morning Brew Daily

Report any issue

Source

Recorded11 Jul 2022

Publisheranchor.fm ↗

Handlerec:9885830

Show notes

In this episode of the backend engineering show I’ll discuss Fill Factor index property, an important key parameter for a good performing database. I will also discuss how it is a double edge sword and can break or Make your db. Chapters 0:00 Intro 1:48 Start of the Show 4:30 Database Storage Representation 6:30 IO Cost 10:00 Index Page 13:30 Page Splits Cost 18:00 Indexing UUIDs 19:45 FillFactor 23:15 Bad FillFactor values 26:40 Fragmentation In Indexes 30:30 Summary Fundamentals of Networking for Effective Backends udemy course (link redirects to udemy with coupon) https://network.husseinnasser.com Fundamentals of Database Engineering udemy course (link redirects to udemy with coupon) https://database.husseinnasser.com

Ask this episode

“What did the council decide on item 42?” — answered with the speaker and the moment.

Sign in