Postgres Replication at speed with PeerDB's S...

Scott talks with Aran Khanna, co-founder and CEO of Archera, about a new category of cloud financial tooling: "Insured Commitments." Instead of locking into 1- or 3-year reserved instance contracts and hoping your usage matches, Archera offers commitments as short as 30 days. The ...  Show more

Scott talks with Skyla Loomis, General Manager of IBM Z Software, about the ongoing relevance of mainframes in 2026. They discuss the enduring power of mainframes, how generative AI is transforming COBOL modernization, and why enterprise infrastructure still runs on IBM Z. Skyla ...  Show more

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

pganalyze: - Weekly series "5mins of Postgres": - How Postgres chooses which index to use: - CMU databases courses: - Postgres community: As well as social links: - Mastodon: - Twitter/X: @pganalyze, @LukasFittl - GitHub: @pganalyze, @lfittl - LinkedIn. 

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 ...

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

< ...