New Releases & 1,000 Times Faster Query | Scaling Postgres 316
Join Over 1,000 Engineers & Get New Episodes Weekly!
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