PostgreSQL at low-level: stay curious!

PostgreSQL is a database that heavily relies on functionality provided by an OS. This approach allows the reuse of some best practices and algorithms of utilizing machine resources like memory or CPU time. But on the other hand, it means PostgreSQL dependency - different configurations of your OS may significantly affect database performance.

In this talk we will discuss how much impact different knobs and options of the Linux kernel have on PostgreSQL and why, what would happen if we run our databases in virtualized environment or inside a container, how to see what's going on inside and how to break something spectacularly.