Scaling Postgres Episode 219 Out-Of-Cycle Release, Should You Upgrade, Postgres Survey, Automatic Indexing

In this episode of Scaling Postgres, we discuss a Postgres 14 out-of-cycle release next week, whether you should upgrade, the state of Postgres survey and a tool for automatic indexing.

Content Discussed

• PostgreSQL 14 out-of-cycle release coming June 16, 2022
• Important PostgreSQL 14 update to avoid silent corruption of indexes
• Notes on updating to PostgreSQL 14.3, 13.7, 12.11, 11.16, and 10.21
• The 2022 State of PostgreSQL Survey Is Now Open!
• An automatic indexing system for Postgres: How we built the pganalyze Indexing Engine
• A balanced approach to automatic Postgres indexing: The new version of the pganalyze Index Advisor
• 5mins of Postgres E21: Server-side backup compression with LZ4 and Zstandard in Postgres 15, and the removal of exclusive backup mode
• Understand PG’s MVCC Visibility Basic Check Rules
• Update on the Trademark Actions Against the PostgreSQL Community
• Re: Update on the Trademark Actions
• Hironobu Suzuki
• Rubber Duck Dev Show Episode 45 | Reviewing the 2022 Rails Community Survey - Part 2

YouTube Video