Summary: <p>Bret and Nirmal are joined by Lukas Fittl of pganalyze to dive into Postgres in containers, in production, and in CI.</p><p><br>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.</p><p>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.</p><p><strong>Be sure to check out the </strong><a href="https://www.youtube.com/live/_tQ1fdI6MiM?si=U9oYNxU-4lrDZsYF&t=229"><strong>live recording </strong></a><strong>of the complete show from February 15, 2024 on YouTube (Ep. #254).</strong></p><p>★Topics★<br><a href="https://pganalyze.com">pganalyze website</a><br><a href="https://www.youtube.com/channel/UCDV_1Dz2Ixgl1nT_3DUZVFw">pganalyze YouTube channel </a><br><a href="https://github.com/pgvector/pgvector">pgvector</a> <br><a href="https://github.com/cloudnative-pg/cloudnative-pg">cloudnative-pg</a> <br><a href="https://access.crunchydata.com/documentation/postgres-operator/latest">Crunch Postgres for Kubernetes</a> <br><a href="https://www.cockroachlabs.com/product/kubernetes">CockroachDB</a></p><p><strong>Creators & Guests</strong></p><ul> <li> <a href="https://podcast.bretfisher.com/people/bret-fisher">Bret Fisher</a> - Host</li> <li> <a href="https://podcast.bretfisher.com/people/lukas-fittl">Lukas Fittl</a> - Guest</li> <li> <a href="https://podcast.bretfisher.com/people/nirmal-mehta">Nirmal Mehta</a> - Host</li> <li> <a href="https://podcast.bretfisher.com/people/cristi-cotovan">Cristi Cotovan</a> - Editor</li> <li> <a href="https://podcast.bretfisher.com/people/beth-fisher">Beth Fisher</a> - Producer</li> </ul> <ul> <li>(00:00) - Intro</li> <li>(01:59) - Is Postgres Underrated?</li> <li>(04:18) - What is pgAnalyze?</li> <li>(05:02) - Database Performance Tuning</li> <li>(11:11) - Postgres in Containers</li> <li>(19:44) - Opinion on kubegres and other operators in managing HA</li> <li>(25:03) - The role of Database Administrators and Data Engineers</li> <li>(31:54) - Running Postgres HA across multi-cluster</li> <li>(39:23) - What does pgnalyze do?</li> <li>(44:45) - The hardest operational problem running Postgres in containers</li> </ul> <br><p><strong>You can also support my free material by subscribing to my </strong><a href="https://www.youtube.com/@BretFisher"><strong>YouTube</strong></a><strong> channel and my weekly newsletter at </strong><a href="https://bret.news/"><strong>bret.news</strong></a><strong>!</strong></p><p>Grab the best <strong>coupons</strong> for my <a href="https://www.bretfisher.com/courses"><strong>Docker and Kubernetes courses</strong></a><strong>.<br></strong>Join my cloud native <strong>DevOps community</strong> <a href="https://devops.fan/"><strong>on Discord</strong></a><strong>.<br></strong>Grab some <strong>merch</strong> at <a href="https://bretfisher.myspreadshop.com/"><strong>Bret's Loot Box</strong></a><br>Homepage <a href="https://bretfisher.com/"><strong>bretfisher.com</strong></a></p>
