Software Engineering Radio - the podcast for professional software developers

SE Radio 583: Lukas Fittl on Postgres Performance

19 snips
Sep 28, 2023
Guest
Lukas Fittl
Lukas Fittl, performance expert of Postgres, discusses database indexing, queries, maintenance, scaling, and stored procedures. They cover the importance of indexing, improving query performance with indexes, vacuuming and database maintenance, and upcoming releases and performance features in Postgres.
Ask episode
Chapters
Transcript
Episode notes
1
Introduction
00:00 • 2min
2
Types of Applications, PostGIS, and Cloud Computing with Postgres
02:25 • 3min
3
The Significance of Database Performance for Web Performance and User Experience
05:48 • 3min
4
The Origins and Motivations behind PG analyze
08:31 • 22min
5
The Importance of Indexing in Database Performance
30:49 • 13min
6
Improving Query Performance with Indexes in Postgres
43:21 • 11min
7
Vacuuming and Database Maintenance
54:21 • 13min
8
Upcoming releases and performance features in Postgres
01:07:29 • 4min