Conference Schedule - PGConf.EU 2015

Back

PostgreSQL performance tuning

Date: 2015-10-27
Time: 09:00 - 12:30
Room: Ballroom B
Level: Intermediate

Good database performance is vital and essential to many business around the globe. Unfortunately many databases are not tuned properly and many SQL queries have not been optimized properly. This training is a frontal assault on all kinds of performance problems bugging databases all over the planet.

Topics:

  • Finding slow queries
  • Fixing missing indexes
  • Dealing with fuzzy searches
  • Tweaking memory parameters
  • Optimizing storage (checkpoints, etc.)
  • Dealing with FILLFACTOR
  • Handling VACUUM
  • Optimizing space consumption
  • Reading execution plans (EXPLAIN, etc.)
  • Approaching performance problems systematically

Speaker

Hans-Jürgen Schönig