PostgreSQL at low level: Stay curious

Description

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.