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
Jan 19
5 Backend Design Patterns for Managing Threads and Sockets
In this video I introduce 5 different design patterns for building backend applications. Each mode explains how a socket listener is established, a connections are established and how threads and connections are managed to read, write and process requests. 
46m 9s
Dec 15
Page Tables
Page tables provide the mapping between virtual memory and physical memory for each process. This means it needs to be as efficient and as fast as possible. I explore the inner workings of page tables in this episode.0:00 Intro2:00 Virtual Memory ⁃ ⁃ 8:00 MMU10:00 Page Tables ⁃ ⁃ ... Show More
46m 39s
Nov 2025
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
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
<p>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 be ... 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
<p>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&#39;t know how to code? You may think you can get by using no-code tools, ... Show More
15m 13s
Feb 2024
InvestTalk 2-23-2024 – Is Your Index Fund Tracking the Right Index?
Understanding 6 qualities of the best indexes can help investors choose among thousands of index funds. Today's Stocks & Topics: VFC - VF Corp., SSNT - SilverSun Technologies Inc., The Magnificent 7, RIO - Rio Tinto PLC ADR, Oil Markets, ENB - Enbridge Inc., PCG - PG&E Corp., War ... Show More
44m 59s
Jan 2024
How to build a role-playing video game in 24 hours
<p>Now you know: The human body can serve as a resonance chamber for <a href="https://physics.stackexchange.com/questions/101913/why-does-a-remote-car-key-work-when-held-to-your-head-body" target="_blank">remote car keys</a>, effectively extending their range.</p><p>A hackathon t ... Show More
14m 14s
Jun 2023
Digital Identity w/ ENS Domains
Always mixing business and education, Khori has major experience managing for-profits and non-profits, with a big love for tech and always being an early adopter. Developing an interest in distributed ledger tech, and being passionate about decentralized inclusion and identity, h ... Show More
1h 17m