Vacuum Is Lying To You? | Scaling Postgres 397

In this episode of Scaling Postgres, we discuss if vacuum is lying to you with regard to index cleanup, an agentic toolkit with MCP server, indexes getting corrupted after an upgrade and $50 Planetscale Metal.

Content Discussed

• VACUUM Is a Lie (About Your Indexes)
• Building AI Agents on Postgres: Why We Built the pgEdge Agentic AI Toolkit
• Introducing The pgEdge Postgres MCP Server - And How to Connect it to Claude Code and Cursor
• Which indexes can be corrupted after an operating system upgrade?
• $50 PlanetScale Metal is GA for Postgres
• Enhancing PostgreSQL OIDC with pg_oidc_validator
• Anonymising PII in PostgreSQL with pgEdge Anonymizer
• What Postgres developers can expect from PGConf.dev with Melanie Plageman
• PostgreSQL 18 Asynchronous Disk I/O - Deep Dive Into Implementation
• Improved Markdown Parsing
• The Road to Deploy a Production-Grade, Highly Available System with Open-Source Tools
• Comparing stats! PostgreSQL 18 against 17
• How does the PostgreSQL Buildfarm check upgrades across versions?
• Why Your Staging Database Never Matches Production
• pgBackRest preview - simplifying manual expiration of oldest backups
• From PGDays to PGCon/fs
• PGIBZ 2025: An Event for the Postgres Community in Ibiza
• PostgreSQL Contributor Story: Nishant Sharma
• Contributions for week 51, 2025
• Improve Aurora PostgreSQL throughput by up to 165% and price-performance ratio by up to 120% using Optimized Reads on AWS Graviton4-based R8gd instances
• Using MotherDuck with PlanetScale
• Postgres 18 is now available
• Zero-Downtime PostgreSQL Maintenance with pgEdge
• Deploying TimescaleDB Vector Search on CloudNativePG Kubernetes Operator
• Own Your Observability: Supabase Metrics API

YouTube Video

Podcast Audio