Postgres in Containers

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