--- title: "Vacuum Is Lying To You? | Scaling Postgres 397" url: https://daily.dev/posts/vacuum-is-lying-to-you-scaling-postgres-397-84wewxukk source_url: https://www.youtube.com/watch?v=0E3AUTxC5zg type: video:youtube source: "Scaling Postgres" published: 2026-05-31T07:44:28.768Z updated: 2026-05-31T07:55:30.953Z tags: ["postgresql"] reading_time: 16 upvotes: 0 comments: 0 language: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # Vacuum Is Lying To You? | Scaling Postgres 397 **[Scaling Postgres](https://daily.dev/sources/scaling-postgres)** · 16 min read · 0 upvotes · 0 comments ## Summary Episode 397 of Scaling Postgres covers several topics. The main focus is on how PostgreSQL's VACUUM has limited effectiveness on B-tree indexes: it removes dead tuple pointers and marks empty pages as reusable, but cannot merge sparse pages, reduce tree depth, or restructure the B-tree. After heavy deletions, index bloat persists and can skew query planner statistics, causing it to prefer sequential scans. The recommended fix is REINDEX CONCURRENTLY rather than more vacuuming. Additional topics include: a beta PG Edge Agentic AI toolkit (MCP server, vectorizer, RAG server, BM25 hybrid search) for using LLMs with any Postgres instance; index corruption risks from OS-level collation changes during upgrades and how logical replication upgrades avoid this; PlanetScale Metal's new $50/month Postgres tier; a PG OIDC validator extension for token caching ahead of OAuth2 in Postgres 18; and PG Edge Anonymizer for PII masking. A consulting corner shares real-world optimization work: query tuning, pre-aggregating data, and replacing LIMIT/OFFSET pagination. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: ## Similar posts on daily.dev - [VACUUM Is a Lie \(About Your Indexes\)](https://daily.dev/posts/vacuum-is-a-lie-about-your-indexes--ht8lqfc6i) · Lobsters · 5 upvotes · 0 comments - [3 Lessons From Nearly Blowing Up a Production Database](https://daily.dev/posts/3-lessons-from-nearly-blowing-up-a-production-database-6ayktn7ub) · Atomic Spin · 0 upvotes · 0 comments - [My queries to monitor autovacuum](https://daily.dev/posts/my-queries-to-monitor-autovacuum-vscqbjwpm) · CYBERTEC PostgreSQL · 0 upvotes · 0 comments --- Tags: [#postgresql](https://daily.dev/tags/postgresql) [View this post on daily.dev](https://daily.dev/posts/vacuum-is-lying-to-you-scaling-postgres-397-84wewxukk)