Ottertune Is Dead! | Scaling Postgres 321

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 the shutdown of Ottertune, how schema changes cause locks and how to avoid them, the benefits of on conflic do nothing, and pgvectorscale.

Want to learn more about Postgres performance?
Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/cours...

Timestamps:
00:00 - Intro
00:22 - Ottertune is dead!
00:59 - Schema changes and the Postgres lock queue
03:30 - Reduce Vacuum by Using “ON CONFLICT” Directive
04:49 - pgvectorscale
06:24 - PostgreSQL Development Conference 2024 - Review
07:03 - Extension Ecosystem Summit 2024
07:21 - POSETTE 2024 [Review]
07:29 - [YouTube] Posette 2024 Talks
07:42 - POSETTE 2024 — How to Work with Other People
07:55 - The time keepers: pg_cron and pg_timetable
08:57 - The surprising logic of the Postgres work_mem setting, and how to tune it
10:37 - Outro

#postgres #postgresql