Show Notes
Bret and Nirmal are joined by Lukas Fittl of pganalyze to dive into Postgres in containers, in production, and in CI.
😇 My new GitHub Security workshop has launched! A free 2-hour workshop with hands-on labs to harden your repos and your workflows from common supply chain attacks. I'll cover how attackers are getting in, and then we'll lock down a sample repo so you know what needs to be done to protect your code. You'll leave with a deep understanding of risks and mitigations as well as a list of helpful tools to keep your repos safe, including my new "gasa" tool for scanning your repos and orgs. Lukas is an expert and founder of pganalyze, and I invited him on the show to explain a lot of this to us and catch us up with what's going on in the Postgres community, particularly when it comes to containers and production. We dive into everything around containers with Postgres, some of the new stuff going on in Postgres Land, including tuning and stuff I didn't even know about Postgres, including storing NoSQL data, vector databases for AI and more. Be sure to check out the live recording of the complete show from February 15, 2024 on YouTube (Ep. #254). ★Topics★ pganalyze website pganalyze YouTube channel pgvector cloudnative-pg Crunch Postgres for Kubernetes CockroachDB Creators & Guests
Bret Fisher - Host
Lukas Fittl - Guest
Nirmal Mehta - Host
Cristi Cotovan - Editor
Beth Fisher - Producer
(00:00) - Intro
(01:59) - Is Postgres Underrated?
(04:18) - What is pgAnalyze?
(05:02) - Database Performance Tuning
(11:11) - Postgres in Containers
(19:44) - Opinion on kubegres and other operators in managing HA
(25:03) - The role of Database Administrators and Data Engineers
(31:54) - Running Postgres HA across multi-cluster
(39:23) - What does pgnalyze do?
(44:45) - The hardest operational problem running Postgres in containers
You can also support this podcast by subscribing to my YouTube channel and my monthly newsletter at bret.news! Grab the best coupons for my GitHub, Agents, Docker, and Kubernetes courses. Join my cloud native DevOps community on Discord. Grab some merch at Bret's Loot Box Homepage bretfisher.com
★ Support this podcast ★
More from DevOps and Docker Talk: Cloud Native Interviews and Tooling
Control Plane CEO Doron Grinstein joins me to discuss how they’ve created an AI-native cloud API that virtualizes multi-cloud and hybrid cloud to simplify management and ship faster. Watch the video of this episode.
What does an AI-native CI look like? The Semaphore team joins me to talk about their focus on making your agent harness the gateway to testing, fixing, and deploying your code. Video podcast version here: https://youtu.be/HzXAdtVrW70
OpenChoreo is a “batteries included”, AI-native Kubernetes platform stack for Platform Engineers that combines GitOps, Observability, AI Agents, and Workflows into a custom K8s distribution “super pack” that is managed via Backstage, CLI, API, or MCP. Check out the video podcast version here: https://youtu.be/AqGWjxEfj2g
Michael Irwin of Docker joins me to run through Gordon AI improvements, Docker Hardened Images and what's now free, Docker Sandboxes for running agents in proper isolation, Model Runner updates including MLX support on Mac, MCP Toolkit dynamic discovery, and the newly renamed Docker Agent with its GitHub Action for automating PR reviews and docs checks. Check out the video podcast version here: https://youtu.be/dTF3b36Bq6w
Bret is joined by the founders of Plakar - Julien Mangeard and Gilles Chehade - to nerd out over backup engineering. The kind where you're building your own file formats and cryptographic layers, not just wiring up cron jobs. We get into how Plakar deduplicates and encrypts at the source so your cloud provider never sees your keys. Also, their snapshot model has no chain dependencies, which means you can delete any backup without breaking the others. We had a fun hour of backup horror stories, ransomware pragmatism, where I'm lobbying hard for a Docker volume integration. Check out the video podcast version here: https://youtu.be/OPRK5osKQHI