11K Faster Configuration Change | Scaling Postgres 305

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 one configuration change that resulted in an 11,000 times faster query, why Postgres is not using your index, backported PG improvements and parallelism with TOAST.

Want to learn more about Postgres performance?
Join my FREE mini-course called the PostgreSQL Performance Starter Kit here: https://www.scalingpostgres.com/cours...

Timestamps:
00:00 - Intro
00:39 - 100x Faster Query in Aurora Postgres with a lower random_page_cost
03:34 - Why isn't Postgres using my index?
04:58 - Quick Benchmark: PostgreSQL 2024Q1 Release Performance Improvements
06:53 - TOAST and its influences on parallelism in PostgreSQL
08:38 - The default value of fdw_tuple_cost was updated to 0.2. What does that mean?
09:49 - First Row of Many Similar Ones
10:49 - 11 Lessons to learn when using NULLs in PostgreSQL
11:19 - Uncovering and Exploring ROW Constructors in PostgreSQL
11:45 - Prepared statements for psql operations
12:31 - The Rest is History: Investigations of WAL History Files
13:01 - Outro

#postgres #postgresql