logo
episode-header-image
Oct 2023
13m 2s

Why create Index blocks writes

Hussein Nasser
About this episode

Fundamentals of Database Engineering udemy course (link redirects to udemy with coupon) https://database.husseinnasser.com Why create Index blocks writes In this video I explore how create index, why does it block writes and how create index concurrently work and allow writes. 0:00 Intro 1:28 How Create Index works 4:45 Create Index blocking Writes 5:00 Create Index Concurrently

Up next
Jul 10
How a query optimization gave birth to infinite scroll
The infinite scroll in social media as we know it today is despised by all. But it always start as a bad idea. It originated as a result of UI change to relief the backend database from inefficient queries. I explore this in this episode of the backend engineering. 0:00 Intro1:00 ... Show More
21m 20s
Jun 17
Postgres is half as fast in Linux 7.0
An aws engineer discovered a 50% regression in postgres throughput while testing the new Linux 7.0 kernel. The cause turns out to be massive TLB and page faults exacerbated by Postgres process-based design. In this backend engineering show episode I dive deep into how this was di ... Show More
34m 8s
Jun 8
Don't let AI rob you
A discussion about why many engineers still love the struggle, the mistakes, and the process of figuring things out themselves. This is how we grow and get better and stronger. Letting AI do everything (even though it can’t) robs us this feeling.. 
31m 53s
Recommended Episodes
Oct 2023
166: Speedy Database Queries with Lukas Fittl
pganalyze: - Weekly series "5mins of Postgres": - How Postgres chooses which index to use: - CMU databases courses: - Postgres community: As well as social links: - Mastodon: - Twitter/X: @pganalyze, @LukasFittl - GitHub: @pganalyze, @lfittl - LinkedIn. 
1h 12m
Jul 2014
2. Introduction to HTML
<p>Please fill out this survey so I know what type of content YOU PERSONALLY WANT: <a href="https://beachangeagent.typeform.com/to/hQLXrjUS">⁠https://beachangeagent.typeform.com/to/hQLXrjUS</a></p> 
29m 14s
Jun 2020
We Are Now Living In A Digital Police State - Find Out Why & How Today With David Icke
BROADCAST YOURSELF - 8 Week Course: https://londonreal.tv/by/ 2021 SUMMIT TICKETS: https://londonreal.tv/summit/ NEW MASTERCLASS EACH WEEK: http://londonreal.tv/masterclass-yt LATEST EPISODE: https://londonreal.link/latest WATCH ROSE/ICKE IV: https://freedomplatform.tv/icke  
5m 7s
Nov 2015
21. Getting Into Web Dev & Learning How to Learn
<p>Please fill out this survey so I know what type of content YOU PERSONALLY WANT: <a href="https://beachangeagent.typeform.com/to/hQLXrjUS">⁠https://beachangeagent.typeform.com/to/hQLXrjUS</a></p> 
31m 59s
Aug 2024
The UNLOCK For Your Personal Brand in 2024 | The Dept Ep. 40
tail spinning
47m 13s
Aug 2024
How To Create Your Niche Of One (In 4 Steps)
tail spinning
38m 6s
Mar 2024
415[Marketing] Webinar Secrets | Author Interview Jason Fladlien - One to Many
How to Double Your Weekly Output while working 10-20 fewer hours/week using a 9 Second Forcing Function Trigger: https://focusblocks.io How to make more progress in the next 3 months than you did in the last 1 year: https://2000books.com/ql Watch this episode on our YouTube Chann ... Show More
1h 4m
May 2019
How to Write Ranking YouTube Descriptions
In this episode, I show you how to gain more YouTube views and YouTube subscribers, by writing ranking YouTube descriptions. I go over a free template you can use that will rank your videos higher in YouTube search with great YouTube SEO. Keywordtool.io https://keywordtool.io/ Mu ... Show More
6m 7s