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
Mar 19
Building the Internet with sendmail's Eric Allman
In this episode, in association with the ACM ByteCast, Scott talks with Eric Allman, one of the foundational figures of the early internet. Best known for creating Sendmail, the mail transfer agent that powered a large portion of global email infrastructure through the formative ... Show More
32m 37s
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
