#3 - Detecting performance problems and fixing them (AM)
Time: 09:00 - 12:00
Everybody faces database performance problems now and then. Most likely this will never change. However, the important thing is to detect and fix issues as they pop up. This is exactly what this course is all about.
How to detect performance problems - Tracking down slow queries - Hunting I/O problems - Optimizing postgresql.conf for speed - Optimizing storage - Finding slow stores procedures - Playing with locking - Trading durability for speed - Improving parallel queries