Musings on technology from long time database professional.
Some times we can’t dedicate 100% of our attention to blog posts, or videos, or webinars, so whether you are working, or just working out. you can enjoy these podcasts alongside the daily grind
All content for The Spoken Nerd is the property of Connor McDonald and is served directly from their servers
with no modification, redirects, or rehosting. The podcast is not affiliated with or endorsed by Podjoint in any way.
Musings on technology from long time database professional.
Some times we can’t dedicate 100% of our attention to blog posts, or videos, or webinars, so whether you are working, or just working out. you can enjoy these podcasts alongside the daily grind
Back to Basics: The highs and lows of the High Water Mark
The Spoken Nerd
32 minutes 58 seconds
3 years ago
Back to Basics: The highs and lows of the High Water Mark
Databases are incredibly sophisticated pieces of software, and hence as they mature, the algorithms and logic behind what at first glance would seem to be trivial functionality are often amazing in their cleverness and cunning. In this episode we'll explore the complexity and sophistication around what would seem to be the simplest of questions: When I want to insert a row into a table, where should the database store that row? For a database to answer that question, it needs to know which table blocks are empty, which ones are full and how to manage multiple sessions all asking for which blocks to use all at the same time. Time for some insight into the High Water Mark for a database table, and its impact on your applications.
If you like this episode, be sure you hit the Like button and share it with your colleagues. Catch me on Twitter at https://twitter.com/connor_mc_d if you have comments or questions.
The Spoken Nerd
Musings on technology from long time database professional.
Some times we can’t dedicate 100% of our attention to blog posts, or videos, or webinars, so whether you are working, or just working out. you can enjoy these podcasts alongside the daily grind