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.

Up next
Aug 21
Focus Friend by Hank Green is #1 in the App Store with Bria Sullivan
In this episode, Scott sits down with Bria Sullivan, developer and founder of Honey B Games, to unpack the viral success of Focus Friend—the cozy productivity app that dethroned ChatGPT at the top of the App Store. Co-created with Hank Green, Focus Friend gamifies focus with a so ... Show More
38m 34s
Aug 14
Inside the Maker Mindset with Roboticist Aaed Musa
From wrist‑mounted CD launchers to rope‑driven quadrupeds, Purdue engineering student and YouTuber Aaed Musa turns wild ideas into precision‑crafted reality. On Hanselminutes, he joins Scott Hanselman to share the art, grit, and storytelling behind his most ambitious projects — a ... Show More
31m 47s
Aug 7
Learning to Code with AI and Steve Klabnik
Steve Klabnik wasn't a fan of AI. He knows how to code at high and low levels...but then he tried again. Now he's making more, shipping more, coding more, and having more fun. Is this a moral choice or a techincal one or both? 
43m 12s
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
- pganalyze: https://pganalyze.com/- Weekly series "5mins of Postgres": https://www.youtube.com/channel/UCDV_1Dz2Ixgl1nT_3DUZVFw- How Postgres chooses which index to use: https://pganalyze.com/blog/how-postgres-chooses-index- CMU databases courses: https://db.cs.cmu.edu/courses/- ... Show More
1h 12m
Nov 2021
Postgresql index bloat | The Backend Engineering Show
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 ep ... Show More
27m 53s
Jun 2022
Sorting in Postgres 15 is 371% faster in certain cases
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 Resources https://www.phoron ... Show More
9m 37s
Apr 2020
When should you shard your database?
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 need ... Show More
21m 19s
Feb 2021
UUIDs are Bad for Performance in MySQL - Does Postgres Win? Let us Discuss
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     http ... 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 ht ... 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
In this video, I explain how both Postgres and MySQL store their indexes and their effect on reads vs writes. Let us discuss 0:00 Intro 1:00 Tables 2:00 Indexes 3:20 Indexing in Postgres 5:00 Indexing in MySQL 6:35 What Happens on Update on Postgres 7:20 What Happens on Update on ... Show More
13m 50s
Listen to millions of songs and podcasts on Anghami