Index Fill Factor | The Backend Engineering Show
The Backend Engineering Show with Hussein Nasser
00:00
Using a Fill Factor in an Index
As you insert, you crete a new page. Once you reach 80 % of that page, stop, don't use it any more. If you have random inserting values right in the page, things like goids, like oide that are actually random, or even into ger bers that you know it's random, it's going to be coming in random fashion. Then having a fill factor of 80% is all subjective and really depends on, i guess, use cases and testing and trial and error. I'm going to talk about, we have to sometimes the filth actors actually a twoa double eged,. 'm ging to come to that in a minute,
Transcript
Play full episode
