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
Jun 13
kTLS - Kernel level TLS
Fundamentals of Operating Systems Course https://oscourse.winktls is brilliant.TLS encryption/decryption often happens in userland. While TCP lives in the kernel. With ktls, userland can hand the keys to the kernel and the kernel does crypto. When calling write, the kernel encryp ... Show More
22m 55s
May 9
The beauty of the CPU
If you are bored of contemporary topics of AI and need a breather, I invite you to join me to explore a mundane, fundamental and earthy topic.The CPU.A reading of my substack article https://hnasr.substack.com/p/the-beauty-of-the-cpu 
9m 38s
Apr 2025
Sequential Scans in Postgres just got faster
This new PostgreSQL 17 feature is game changer. They know can combine IOs when performing sequential scan. Grab my database coursehttps://courses.husseinnasser.com 
27m 36s
Recommended Episodes
Aug 2021
Capital Markets #1 with MSCI CEO Henry Fernandez: What goes into an index?
The MSCI origin story [1:07]How does an index get constructed? [6:51]How do you keep an index accurate? [11:42]MSCI business model... how do they get paid? [16:27]MSCI, competition, and why not an open source index? [23:14]ESG and investment objectives [27:00]ESG disclosure frame ... Show More
56m 55s
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 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
Apr 2018
Algorithms
Can algorithms help writers think more clearly and create innovative work ? On this week's 'Algorithm Verb' Ian McMillan is joined by Helen Arney, who performs a brand new love-song (written for the programme) using search engine algorithms, by Eugenia Cheng, a mathematician and ... Show More
43m 28s
Feb 2024
Custom Indexing
For investors, tracking an index has allowed them to target exposure within specific sectors and industries. And the advent of ETF or exchange traded fund investing has made this readily accessible to investors. But, imagine if you could invest in the what you think are the best ... Show More
16m 5s
May 2023
Blockchain Scalability w/ Cartesi
Omran is a tech-savvy with a background in software architecture for more than 15 years, having worked in big companies such as Google and Intel. Max, on the other hand, even without a tech background, has always been curious about innovation and technology, using business models ... Show More
1h 3m
Jan 2024
How To Build A Tech Startup With No Technical Skills | Dalton & Michael Podcast
Based on the thousands of companies YC has funded over the years, the biggest common element between all successful startups is having technical talent on the founding team. But what do you do if you don't know how to code? You may think you can get by using no-code tools, pa ... Show More
15m 13s
May 2022
Война. День 77. Как война привела к расколу коллектива “Яндекса”
Как российское вторжение в Украину раскололо коллектив компании “Яндекс”? Об этом мы говорим с автором текста “Мы замучились бороться” Светланой Рейтер. Светлана - спецкор издания “Медуза”, которое признано в России СМИ, выполняющим функции иноагента. Мы вынуждены упоминать это п ... Show More
24m 21s
May 2024
Google Algorithm Leak: Why So Many SEOs Have Suffered
E329: Yesterday's Google Algorithm Leak showed why so many SEOs, webmasters, and marketers have suffered. Here are my takeaways after having 24 hours to think about the absolute information bomb dropped into the digital marketing community yesterday. 0:00 Biggest Google Leak Ever ... Show More
15m 57s