New Releases & 1,000 Times Faster Query | Scaling Postgres 316

In this episode of Scaling Postgres, we discuss new Postgres releases, optimizing a query to be 1,000 times faster, custom vs. generic plans and the pgtt extension.

Content Discussed

• PostgreSQL 16.3, 15.7, 14.12, 13.15, and 12.19 Released!
• Postgres CVE-2024-4317 and how to fix the system views
• PG 17 Preliminary Release Notes
• Making a Postgres query 1,000 times faster
• Custom vs generic plan
• Activating cached feature flags instantly with notify triggers
• Use of “pgtt” Extension in Self Managed vs. Cloud Products
• When to split patches for PostgreSQL
• Time Partitioning and Custom Time Intervals in Postgres with pg_partman
• PGXN Language Poll Result
• RAG With PostgreSQL
• Removing Bloat with pg_repack Extension
• Understanding PostgreSQL Fill Factor: Benefits, Drawbacks, and Best Practices
• PGSQL Phriday #016: Query Tuning
• Deep Dive into PostgREST - Time Off Manager (Part 1)
• Advanced psql scripting with coproc
• PG Phriday: On the Move
• Philip Marks
• Understanding Multi-Master Architecture in PostgreSQL: Benefits and Trade-offs
• Troubleshooting PostgreSQL on Kubernetes With Coroot
• Extension Summit Topic Review
• Git Filters
• How to Collapse Your Stack Using PostgreSQL for Everything
• Conversion Chronicles – Invisible Indexes in Oracle to PostgreSQL Migration.
• Conversion Chronicles – Mapping Oracle Number Data types using AWS SCT and Ora2pg.
• I will be speaking at POSETTE: An Event for Postgres!
• Back from PGConf Belgium 2024
• What’s new with Postgres at Microsoft, 2024 edition
• How to Implement RAG With Amazon Bedrock and LangChain
• What you get when you think of Postgres storage as a transaction journal
• Database branching workflows: A guide for developers
• Create up to 1,000 Neon projects without extra cost

YouTube Video

Podcast Audio