Index Fill Factor | The Backend Engineering Show

Рет қаралды 6,789

Күн бұрын

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)
network.hussei...
Fundamentals of Database Engineering udemy course (link redirects to udemy with coupon)
database.husse...
Introduction to NGINX (link redirects to udemy with coupon)
nginx.husseinn...
Python on the Backend (link redirects to udemy with coupon)
python.hussein...
Become a Member on KZfaq
/ @hnasr
Arabic Software Engineering Channel
/ @husseinnasser
🔥 Members Only Content
• Members-only videos
🏭 Backend Engineering Videos in Order
backend.hussei...
💾 Database Engineering Videos
• Database Engineering
🎙️Listen to the Backend Engineering Podcast
husseinnasser....
Gears and tools used on the Channel (affiliates)
🖼️ Slides and Thumbnail Design
Canva
partner.canva....
Stay Awesome,
Hussein

Пікірлер: 17

@addiegupta 2 жыл бұрын

"sometimes databases have feelings. You have to care about the feelings" 🤣

@artal580 Жыл бұрын

That's a very clarifying explanation of how indexes work, thank you for all the great content. May I ask how does the situation change when you have to add another index (once you have already existing data) to a column? In the context of how does (postgres for example) the db assign new records to pages and how the new index fulfilment value will impact that futureproofness/wasted space tradeoff. I'm a beginner backend developer myself and find so helpful your content, thank you again for diving deep in this architecture/low level topics

@addiegupta 2 жыл бұрын

"Monotokotobotokarati" - Hussein Nasser, 2022

@addiegupta 2 жыл бұрын

Great video as always

@kranium45 2 жыл бұрын

Great content, funny and informative

@hnasr 2 жыл бұрын

Thanks! And big ups for the profile pic, one of my favorite games!

@danku1013 2 жыл бұрын

sequential guids are not inferior in the performance to integer values

@hnasr 2 жыл бұрын

I agree, theoretically sequential UUIDs should be compared to integers. They might take more IOs compared to integers though just because of their size (64bit vs however data type UUID uses 128 bit in some cases and more if implemented as a string)

@i_sometimes_leave_comments Жыл бұрын

That took rubber ducky debugging to a-whole-nother level

@charliesta.abc123 2 жыл бұрын

Awesome talk man. That disadvantage of reading nulls kind of makes it not worthwhile

@vibekdutta6539 2 жыл бұрын

My money dont wiggle wiggle LMAO. I hope you are doing well Hussein

@CameronFlint07 2 жыл бұрын

MONOTONIC 🤣

@Gns89 2 жыл бұрын

monotonically increasing

@Riborwahz 2 жыл бұрын

Bro please don't delay your speech this much it make us feel that we waste most of the time

@danieljayne8623 2 жыл бұрын

1.5x speed

@addiegupta 2 жыл бұрын

Hes probably one of the few educators you can watch and feel as if its a normal conversation and not some heavy course material. You should try increasing the playback speed

@FuzailShaikh 2 жыл бұрын

I watch his videos at 2x