This site is about a previous instance of this event. For the current event, please see the updated site.

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


Andres Freund