PostgreSQL at low level: Stay curious
Dmitrii Dolgov takes a deep dive into how to troubleshoot intricate performance issues in PostgreSQL using such tools as strace, perf, extended Berkeley Packet Filter (eBPF). And stay curious.
| Talk Title | PostgreSQL at low level: Stay curious |
| Speakers | Dmitrii Dolgov (Zalando) |
| Conference | O’Reilly Velocity Conference |
| Conf Tag | Build systems that drive business |
| Location | Berlin, Germany |
| Date | November 5-7, 2019 |
| URL | Talk Page |
| Slides | Talk Slides |
| Video | |
PostgreSQL does not work in at vacuum; it relies heavily on functionality provided by an underlying platform. And sometimes to answer questions such as tracking down a transient performance issue that’s hard to investigate from a database-only point of view, determining how many layers of abstraction your database is working on, or the difference between running your database on bare metal, VM, or inside a container, you have to step back and look at the problem from a different point of view. Dmitrii Dolgov takes a deep dive into how to troubleshoot intricate performance issues from a point of view other than database only (e.g., lock preemption problems on VM, shared memory segment limitations, or memory reclaim process within a container) in PostgreSQL using such tools as strace, perf, extended Berkeley Packet Filter (eBPF). And stay curious.
