Migrating to pg_hardstorage | Scaling Postgres 427

In this episode of Scaling Postgres, we discuss migrating to pg_hardstorage for Postgres backup, PG 19 Beta 2 is released, collecting log stats with pg_stat_log and PG 19 checkpoint additions.

Content Discussed

• Moving to pg_hardstorage without changing your recovery strategy
• PostgreSQL 19 Beta 2 Released!
• pg_stat_log
• pg_stat_log Github
• Looking Forward to Postgres 19: Checkpoint Control
• Postgres 19 Compression: from pglz to LZ4
• Building the OAPE PostgreSQL Certification
• PostgreSQL vs Destructive Time Travel: The Year 2038 Problem
• Every UPDATE Leaves a Ghost: MVCC, Bloat, and VACUUM in PostgreSQL
• Working on Postgres after 13 years on SQL Server with Panagiotis Antonopoulos
• Upgrading PostgreSQL 9.6 to 17 with pg_upgrade
• TQuel Paper: Implementing Temporal Operators in Postgres
• Openness or Oblivion
• Prairie Postgres July Meetup: Proudly Sourced at Midwest!
• Contributions for week 28
• Big Apple, Big PostgreSQL: EDB at Postgres Summit US 2026
• New Query Advisor Insights: Inefficient Index Use, work_mem tuning, and OR to UNION rewrite
• Spock 6: The Only Logical Choice
• What's New in Tiger Cloud: Bigger Performance Gains, Wider Platform Reach, Better Visibility
• Unified Logs is now in open beta
• Supabase Pipelines is now in Public Alpha
• Observability for every Supabase project with Grafana Cloud
• Debug your Postgres from the terminal: a tour of `neon inspect db`
• AI-powered incident analysis for Amazon RDS using automated forensic artifacts
• Migrating mission-critical payments at Nubank to Amazon Aurora PostgreSQL
• Connection pooling strategies in Amazon Aurora DSQL

YouTube Video

Podcast Audio