Join Scott Hanselman as he sits down with Sai Srirampur, as they explore the intricacies of Postgres Replication and how it can be turbocharged using PeerDB. In the realm of databases, Postgres Replication is like a well-choreographed dance between servers. Sai takes us behind the scenes, revealing the steps involved and how it can be made faster and cheaper ... Show More
May 14
Cloud Commitments Without the Lock-In with Archera's Aran Khanna
Scott talks with Aran Khanna, co-founder and CEO of Archera, about a new category of cloud financial tooling: "Insured Commitments." Instead of locking into 1- or 3-year reserved instance contracts and hoping your usage matches, Archera offers commitments as short as 30 days. The ... Show More
31m 40s
May 7
How IBM Z Is Modernizing Mainframes with Skyla Loomis
Scott talks with Skyla Loomis, General Manager of IBM Z Software, about the ongoing relevance of mainframes in 2026. They discuss the enduring power of mainframes, how generative AI is transforming COBOL modernization, and why enterprise infrastructure still runs on IBM Z. Skyla ... Show More
31m 43s
Apr 30
Making opinionated AI tooling decisions with Nimbalyst's Greg Hinkle
Greg Hinkle, co-founder of Nimbalyst and former VP of Software Engineering at Salesforce, joins Scott to discuss the future of AI-assisted development. They explore the challenges of managing multiple AI coding agents, finding flow state in an agentic world, and why visual worksp ... Show More
31m 34s
Jun 2022
Sorting in Postgres 15 is 371% faster in certain cases
<p>Fantastic gains in Postgres 15! improved sorting by 371%. Normally you can avoid sorting by using an index access path. However, you can’t always have an index on every group by, order by, join or distinct predict. This will come handy. Let us discuss</p>
<p>Resources</p>
<p>< ... Show More
9m 37s
<p>In this video, I explain how both Postgres and MySQL store their indexes and their effect on reads vs writes. Let us discuss</p>
<p><br></p>
<p>0:00 Intro</p>
<p>1:00 Tables</p>
<p>2:00 Indexes</p>
<p>3:20 Indexing in Postgres</p>
<p>5:00 Indexing in MySQL</p>
<p>6:35 What Hap ... Show More
