The Stack Overflow Podcast How to write high-performance SQL for your Postgres database
Sep 29, 2023
The podcast discusses how to optimize SQL databases for high performance, focusing on Postgres. They cover the role of indexes, the benefits of local infrastructure, and the addition of vector databases to Postgres. They also share humorous incidents and promote their video show, Five Minutes of Postgres.
Chapters
Transcript
Episode notes
1 2 3 4 5
Introduction
00:00 • 2min
Career Journey, Database Optimization, and Scalability
01:51 • 15min
The Importance of Indexes in Improving Postgres Database Performance
16:50 • 4min
Adding Vector Databases to Postgres: Longevity, Adaptability, and the PG Vector Extension
21:03 • 2min
Community-created content, humorous incident, and promotion of Five Minutes of Postgres
22:46 • 2min