Scaling Postgres Episode 197 Explain Analyze Buffers | Healthier Postgres | 2021 Review | High Availability Aspirations

In this episode of Scaling Postgres, we discuss including buffers with explain analyze, having a healthier Postgres DB, the events of 2021 and aspiring for greater high availability solutions.

Content Discussed

• EXPLAIN (ANALYZE) needs BUFFERS to improve the Postgres query optimization process
• Five Tips For a Healthier Postgres Database in the New Year
• A short summary of the Year 2021 in the PostgreSQL ecosystem
• Postgres in 2021: An Observer's Year In Review
• PG Phriday: Defining High Availability in a Postgres World
• Postgres Data Dictionary for everyone
• [YouTube] Evaluating PostgreSQL Compatibility in Distributed SQL Databases
• Fixing a PostgreSQL cluster that has no superuser
• Ecommerce customer names with interesting Unicode characters
• Kubernetes + Postgres Cluster From Scratch on Rocky 8
• Triggers & Stored Procedures for pure data integrity logic and performance
• SQL to avoid data corruption in race conditions with SERIALIZABLE
• Vibhor Kumar
• Rubber Duck Dev Show Episode 23 | When Should You Mock or Stub?
• Rubber Duck Dev Show Episode 24 | Talking Ruby & Rails with Andrew Mason