Postgres Replication at speed with PeerDB's Sai Srirampur| Listen on Anghami

Jun 26

SKY ENGINE AI's Dr. Malc Souter on AI-Generated Training Data

In this episode Scott talks with Dr. Malc Souter, a computer graphics algorithms PhD and former Hollywood special effects artist, now bringing his rendering expertise to AI at SKY ENGINE AI. They dive deep into the surprising power of synthetic data, exploring when fake can outpe ... Show More

32m 14s

Jun 19

Dave Barry is the Class Clown: The Memoirs of a Professional Wiseass

When authors want to talk about their book they go on a book tour and often they go to large companies like Microsoft and speak to us in person. I had the opportunity to interview Dave Berry in person and I jumped at it. I grew up reading his humor column syndicated in The Oregon ... Show More

46m 7s

Jun 12

Startup Mindsets with Earl Valencia

What does it really take to succeed in today’s fast-paced, innovation-driven world? In this episode of Hanselminutes, Scott Hanselman chats with Earl Valencia—acclaimed tech leader, venture-backed founder, and author of Startup Mindsets: A Blueprint to Thrive in an Innovation-Dri ... Show More

32m 31s

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

Postgres Replication at speed with PeerD...