logo
episode-header-image
Feb 2024
27m 6s

Postgres Replication at speed with PeerD...

SCOTT HANSELMAN
About this episode
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
Up next
Nov 20
C++ is Still Here, Still Powerful with Gabriel Dos Reis
<p>In a world of Rust, Go, and Python, why does C++ still matter? Dr. Gabriel Dos Reis joins Scott to explain how C++ continues to shape everything from GPUs and browsers to AI infrastructure. They talk about performance, predictability, and the art of balancing power with safety ... Show More
35m 50s
Nov 13
Why Postgres? and why now? with Claire Giordano
<p>Postgres has quietly become the world’s favorite database...running startups, governments, and global clouds alike. Scott talks with Claire Giordano, long-time Postgres advocate and technologist, about the database’s unlikely rise from academic roots to modern dominance. They ... Show More
36m 11s
Nov 6
The Past Still Boots with the Interim Computing Museum's Stephen Jones
<p>Scott talks with Stephen Jones of the new Interim Computing Museum, about the craft of bringing old computers back to life. From wire-wrapped boards to tape drives and terminals, this episode dives into why running the old systems — not just displaying them — matters for under ... Show More
40m 46s
Recommended Episodes
Jul 2021
MySQL Statement-based Replication might not be a good idea
Replication is the process of pushing changes from the master node to worker replica nodes in a database system to allow for horizontal scalability. One of the methods of replication is statement-based which is popular in MySQL. In this episode of the Backend Engineering Show, I ... Show More
17m 46s
Oct 2023
166: Speedy Database Queries with Lukas Fittl
<p>- pganalyze: <a href="https://pganalyze.com/">https://pganalyze.com/</a></p><p>- Weekly series "5mins of Postgres": <a href="https://www.youtube.com/channel/UCDV_1Dz2Ixgl1nT_3DUZVFw">https://www.youtube.com/channel/UCDV_1Dz2Ixgl1nT_3DUZVFw</a></p><p>- How Postgres chooses whic ... Show More
1h 12m
Nov 2021
Postgresql index bloat | The Backend Engineering Show
<p>Postgresql database implements MVCC by creating a new row version for any update/delete/or insert. While this is a sound implementation to support concurrent transactions reading old version of the rows, it does have some side effects and this is what I want to discuss in this ... Show More
27m 53s
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
Apr 2020
When should you shard your database?
<p>Database Application level sharding is the process of splitting a table into multiple database instances in order to distribute the load. However, Sharding a database is an expensive operation (maintainability and overhead) and I suggest you do that only when you absolutely ne ... Show More
21m 19s
Feb 2021
UUIDs are Bad for Performance in MySQL - Does Postgres Win? Let us Discuss
<p>MySQL is clustered by default on the primary key which means inserts have to be ordered, let us discuss why UUID (random in nature) has bad performance in MySQL and whether postgres wins here. We will also explain why Sequential Writes are Faster than Random in MYSQL and &nbsp ... Show More
21 m
Oct 2021
The cost rolling back transactions (postgres/mysql)
The cost of a long-running update transaction that eventually failed in Postgres (or any other database for that matter. In Postgres, any DML transaction touching a row creates a new version of that row. if the row is referenced in indexes, those need to be updated with the new t ... Show More
9m 25s
Jun 2023
They Enabled Postgres Partitioning and their Backend fell apart
In a wonderful blog, Kyle explores the pains he faced managing a Postgres instance for a startup he works for and how enabling partitioning sigintfically created wait events causing the backend and subsequently NGINX to through 500 errors. We discuss this in this video/podcast ... Show More
33m 38s
Apr 2022
Postgres.js
Rasmus Porsager created Postgres.js –the fastest full-featured PostgreSQL client for Node.js and Deno. Today he joins Jerod for a deep-dive on Postgres, why he created this open source library, and how you can use it to build pg-backed JavaScript applications. Discuss on Changelo ... Show More
50m 6s
Oct 2020
Indexing in PostgreSQL vs MySQL
<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
13m 50s