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

To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episo...

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.

To get access to the free mini-course the PostgreSQL Performance Starter Kit, visit: https://www.scalingpostgres.com/cours...

Timestamps:
00:00 - Intro
00:19 - PostgreSQL 16.3, 15.7, 14.12, and 12.49 Released!
01:21 - Postgres CVE-2024-4317 and how to fix the system views
02:32 - E.1. Release 17
02:47 - Making a Postgres query 1,000 times faster
06:11 - PostgreSQL Performance Starter Kit
06:37 - Custom vs generic plan
08:05 - Activating cached feature flags instantly with notify triggers
09:41 - Use of "pgtt" Extension in Self Managed vs Cloud Products
11:07 - When to split patches for PostgreSQL
12:09 - Time Partitioning and Custom Time Intervals in Postgres with pg_partman
12:53 - RAG With PostgreSQL
14:09 - Outro

#postgres #postgresql