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

Postgres Replication at speed with PeerD...

SCOTT HANSELMAN
About this episode
tail spinning
Up next
Feb 19
That's good Mojo - Creating a Programming Language for an AI world with Chris Lattner
What does it take to design a programming language from scratch when the target isn’t just CPUs, but GPUs, accelerators, and the entire AI stack? In this episode, I sit down with legendary language architect Chris Lattner to talk about Mojo — his ambitious attempt to rethink syst ... Show More
41m 24s
Feb 12
The Rise of The Claw with OpenClaw's Peter Steinberger
There’s a new wave of AI tools that don’t just live in the cloud, don’t just autocomplete code, and don’t just sit in a browser tab. They reach into your local environment, understand your context, and act more like a thinking companion than a chatbot. In this episode, I talk wit ... Show More
43m 44s
Feb 5
The AI Vampire with Gas Town's Steve Yegge
AI is making developers dramatically more productive...so why is everyone so exhausted? In this episode, Scott talks with Steve Yegge, legendary blogger and creator of Gas Town, a multi-agent orchestrator he describes as "Kubernetes for coding agents." Steve shares his theory of ... Show More
34m 30s
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
tail spinning
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
tail spinning
13m 50s
Listen to millions of songs and podcasts on Anghami