Ottertune Is Dead! | Scaling Postgres 321

To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/321-ottertune-is-dead/ 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/courses/postgres-performance-demystified/ 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