Schedule - PGConf.EU 2022
Party tricks for PostgreSQL: perf, ftrace and bpftrace
Dynamic instrumentation in databases world often looks as weird as hacky, but nevertheless it's definitely worth our attention. There are many discussion in hackers evolving around something, what is beneficial to track in logs or informational views, but has too narrow use case to justify any subsequent performance overhead. Is it possible to approach such problems using tracepoints? Most of the time the answer is yes.
In this talk we will discuss how to easily extract various information (think about some useful metric, or just a funny trick for a geek party) from your Postgres, about pros and cons of different methods, and how dynamic instrumentation can help everyone, from dba to project contributors, to get understanding of what's going on when normal monitoring approaches do not work.
The following slides have been made available for this session: