Session
Back#3 - Detecting performance problems and fixing them (AM)
Date: 2017-09-06
Time: 16:00 - 19:00
Room: Stockton
Level: Intermediate
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
many thanks,
hans