Schedule - PGConf.EU 2015
Profiling postgres with perf
Date: 2015-10-29
Time: 14:40–15:30
Room: Palais I-III
Level: Intermediate
In this session we'll discuss instrumenting PostgreSQL with linux' perf suite of profiling tools. Perf is tremendously useful to investigate performance issues, both in production scenarios and for development.
We'll cover:
- how to compile postgres to get meaningful profiles
- overview over the perf utilities
- taking and interpreting CPU profiles
- measuring lock contention for heavyweight-, lightweight- and spin-locks
- a short introduction over modern CPU architecture, and what that means for writing code and profiling code
- defining custom tracepoints, and what to use them for
