Unconventional Advice? | Scaling Postgres 379
Join Over 1,000 Engineers & Get New Episodes Weekly!
In this episode of Scaling Postgres, we discuss when you should reindex, how to handle case insensitive data, how to index jsonb and the top recommendations when doing performance optimizations.
Content Discussed
- Should I rebuild my PostgreSQL index?
- caSe-inSENsiTive
- Indexing JSONB in Postgres
- Bypass PostgreSQL catalog overhead with direct partition hash calculations
- PG Lord of the Ring
- pg_stat_monitor Needs You! Join the Feedback Phase
- Lies, Damn Lies, and LLM Output.
- AI for data engineers with Simon Willison
- CloudNativePG 1.27.0 Released!
- Vector Search Isn't the Answer to Everything. So What Is? A Technical Deep Dive
- CNPG Recipe 21 – Finer Control of Postgres Clusters with Liveness Probes
- PostgreSQL Extensions
- Achieving High Availability in PostgreSQL: From 90% to 99.999%
- Syncing with Postgres: Logical Replication vs. ETL
- GSoC 2025 Project Report, PostgreSQL
- Curt Kolovson
- Postgres in Malmö: Powered by Elly Phneah
- Most Desired Database Three Years Running: PostgreSQL's Developer Appeal
- Free PostgreSQL® in the Cloud - Aug 25
- The PostgreSQL Hacker Helper extension is one year old
- PgPedia Week, 2025-07-27
- Supabase Auth: Build vs. Buy
- Your Neon Branches Can Now Expire Automatically
YouTube Video
Podcast Audio
