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