Schedule - PGConf.DE 2023

PostgreSQL memory usage: where did my memory go?

Date: 2023-06-27
Time: 15:55–16:45
Room: Room 3
Level: Advanced

PostgreSQL relies on the Operating System for memory management. The database performance and response time depends on memory availability, so PostgreSQL requests and releases memory at runtime. But when PostgreSQL deallocates memory, the OS might not do what the database asks for.

This session is a deep dive into the OS and PostgreSQL memory usage principles that will help you master the understanding of how this resource is actually used and managed. You’ll learn how and why memory oversubscription impacts database response time. You’ll see how memory usage gets exaggerated with a growing number of application connections. Lastly, you’ll discover that the OS doesn’t deallocate memory at all times…even when PostgreSQL explicitly asks to take the memory back.


Frits Hoogland