Conference Schedule - PGConf.EU 2015

Back

Profiling postgres with perf

Date: Oct. 29, 2015
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

Speaker

Andres Freund