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
Oct 9
Competence builds confidence with .NET Principal Engineer Safia Abdalla
On this special episode of Hanselminutes, Scott reunites with .NET Principal Engineer Safia Abdalla, nearly 500 episodes and a decade after her first appearance on the show. They reflect on the arc of her career and the evolution of the developer landscape, discussing how buildin ... Show More
36 m
Oct 2
Push your ideas to the web with Netlify CEO Mathias Biilmann
On this episode of Hanselminutes, Scott Hanselman sits down with Netlify CEO Mathias Biilmann, who coined the term Jamstack, to talk about the future of web development in the age of AI. Recorded shortly before the announcement at Netlify Deploy, the conversation explores Netlify ... Show More
34m 13s
Sep 25
The Importance of Pair Programming with Tuple's Johnny Marler
In this episode of Hanselminutes, Scott Hanselman talks with Tuple engineer Johnny Marler about the craft and culture of pair programming. They explore how intentional collaboration can sharpen problem-solving, reduce context switching, and build trust between teammates—especiall ... Show More
33m 50s
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