05:56"Anti-Slop" Designs with Impeccable (a Crash Course) #6 - Other useful Commands
Net Ninja
Video of an unusual storytelling-style Postgres conference talk that tells the story of transaction ID wraparound in PostgreSQL—presented by Boriss Mejías at Citus Con: An Event for Postgres 2023. The story: One dark and cold night in February, talented Postgres support engineer Monica DeBea was the last person in the building, left alone with an almost broken application. The monitoring system she has just put in place immediately started alerting about the age of the oldest transaction. Have you ever heard about transaction ID wraparound in PostgreSQL? This is what Monica was fighting against. Why was vacuum not freezing old transaction ids? The autovacuum process was not doing it, and a manual VACUUM execution was not helping either. Monica searched and searched for the root cause. She kept searching and the clock kept ticking. The sun was gone, her teammates were gone, even the office lights were dark—but Monica was not going to allow any database downtime on her watch. This is a story of Postgres support in the darkest hour. Boriss Mejías is a holistic system software engineer, PostgreSQL solution architect at EDB, free software user, and headbanger. Boriss got his PhD researching distributed self-managing systems and hasbeen working with PostgreSQL since version 9.1. In 2018 he started the PostgreSQL User Group in Belgium. Boriss has presented in many conferences in academia, open source, and Postgres. Being a father of two fantastic daughters, he also has experien
Published 2023-05-08 · Watch on YouTube ↗
Availability and playback restrictions are controlled by the original channel.
05:56Net Ninja
20:40
22:47
09:23Microsoft Developer
05:34
02:05
02:17Allow Google Analytics to measure visits. Your history stays in your browser. Privacy details