logo
episode-header-image
Jan 2022
31m 54s

Index page splits | The Backend Engineer...

Hussein Nasser
About this episode
In this episode of the backend engineering show I discuss the ramification of index page splits which results in fragmented index yielding slow query performance when using indexes. I go through what a page is, how a page is read and written in the database and finally discuss the current solutions to address this problem such as reindexing, fill factor and ... Show More
Up next
Yesterday
CPU and Kernel Page Faults
<p>Page faults occurs when the process tries to access a memory that isn’t backed by a physical page kernel raises a fault which loads a page. It happens on first access, stack expansion, COW, swap and much more. However it comes with a cost. </p><p><br /></p><p>In this episode o ... Show More
48m 37s
Oct 31
Amazon US-EAST-1 Outage in Details
On October 19 2025 AWS experienced an outage that lasted over a day, 10 days later we finally got the root cause analysis and we know exactly what caused the DNS to fail0:00 Summary 5:30 How did Dynamo lost its DNS?13:41 EC2 Errors 16:16 Network Load Balancer ErrorsRCA here https ... Show More
24m 26s
Oct 17
Graceful shutdown in HTTP
There are cases where the backend may need to close the connection to prevent unexpected situations, prevent bad actors or simply just free up resources. Closing a connection gracefully allows clients and backends to clean up and finish any pending requests. In this episode of th ... Show More
25m 49s
Recommended Episodes
May 2024
Erik Darling and Kendra Little Rate SQL Server Perf Tuning Techniques
Erik Darling joins Kendra Little to rate different SQL Server Performance Tuning Techniques in episode 81 of the Dear SQL DBA podcast. We share our opinions of... (deep breath)   Recompile hints, Query Store hints and plan forcing, CTEs, Resource Governor, the legacy cardinality ... Show More
1h 4m
Dec 2019
Just get started: Buying an index
Halfway through this series and we're only just getting to 'buying your first stock'.What have we been talking about... The theme of this episode is all about 'just getting started'. In the spirit of this we are introducing the concept of an index. An index is the perfect opportu ... Show More
24m 28s
Jan 2022
Post Title Growth Hacks that Lead to 1st Page Rankings - Part 3
<p>Today, I will teach you how two strategically placed special characters can dramatically increase the click-through rates of your post titles in Google results.</p> <p>Here are the links mentioned in this episode:</p> <p><strong>RankIQ's SEO Toolset for Bloggers:</strong></p> ... Show More
11m 28s
Jun 2024
The Future of Restaurant SEO with Will Pemble and Page Leap
<p>In this episode, the host welcomes Will Pemble, an entrepreneur who previously founded one of the largest web hosting companies, web.com, and later sold it. Will delves into his journey from web hosting to management consulting and back to his roots in technology and web optim ... Show More
32m 48s
Sep 2023
Optimizing Landing Pages for SEO Success with Jesse Ringer
In this episode, Jesse Ringer joins me to talk about optimizing landing pages for SEO success. Jesse Ringer, the founder of Method and Metric, launched the company in 2017. With over 10 years of experience, Jesse has assisted business owners, entrepreneurs, and marketing teams in ... Show More
40m 3s
Oct 2023
166: Speedy Database Queries with Lukas Fittl
<p>- pganalyze: <a href="https://pganalyze.com/">https://pganalyze.com/</a></p><p>- Weekly series "5mins of Postgres": <a href="https://www.youtube.com/channel/UCDV_1Dz2Ixgl1nT_3DUZVFw">https://www.youtube.com/channel/UCDV_1Dz2Ixgl1nT_3DUZVFw</a></p><p>- How Postgres chooses whic ... Show More
1h 12m
Mar 2024
Speed will win the AI computing battle with Tuhin Srivastava from Baseten
At a time when users are being asked to wait unthinkable seconds for AI products to generate art and answers, speed is what will win the battle heating up in AI computing. At least according to today’s guest, Tuhin Srivastava, the CEO and co-founder of Baseten which gives custome ... Show More
38m 32s
Dec 2023
Detailed.com's "How 16 Companies are Dominating the World's Google Search Results"
<p>E149: Another example of long-form SEO content marketing that attracts tons of links.</p> <p>This article is 13,500 words long and has attracted 738 links from 216 linking domains.</p> <p>If you're looking at how to get backlinks for search engine optimization, listen to this. ... Show More
16m 13s
May 2024
763: Web Scraping + Reverse Engineering APIs
Web scraping 101! Dive into the world of web scraping with Scott and Wes as they explore everything from tooling setup and navigating protected routes to effective data management. In this Tasty Treat episode, you’ll gain invaluable insights and techniques to scrape (almost) any ... Show More
52m 32s
Listen to millions of songs and podcasts on Anghami