Sometimes It Is Slow? | Scaling Postgres 332

To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/332-sometimes-it-is-slow/ In this episode of Scaling Postgres, we discuss what can happen when queries get slow, backup best practices, Postgres emergencies and the state of Postgres survey. 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:33 - “Sometimes, It’s Slow!” 04:55 - PostgreSQL Backup Best Practice 07:04 - Postgres Emergency Room 08:39 - The 2024 State of PostgreSQL Survey Is Now Open! 09:00 - The 2024 State of the Database Landscape Survey 09:18 - VACUUM: Managing and detecting bloat 11:43 - Understanding the Postgres Hackers Mailing List Language 13:20 - Follow-Up: Reduce Vacuum by Using “ON CONFLICT” Directive 13:45 - In-Browser Semantic AI Search with PGlite and Transformers.js 14:28 - Implementing Filtered Semantic Search Using Pgvector and JavaScript 14:44 - Outro #postgres #postgresql