Exploring Linux memory usage and IO performance with PostgreSQL
Presented by:
Frits Hoogland
Frits Hoogland is a database engineer at Service Now, where he works on PostgreSQL databases. He’s an IT professional who believes in applying a scientific approach to performing IT tasks. He spent 25 years working predominantly with Oracle database technology solving performance issues for some of the world’s largest companies. Frits has also worked for the highly-acclaimed Enkitec corporation, co-wrote a book about Oracle Exadata, and helped the University of Rotterdam build a database for DNA to aid pathological gene selection.
Linux and containers are similar in that they provide operating system resources such as memory and storage. These resources, along with CPU and networking, are key factors to achieve optimal performance. However, databases in general and therefore PostgreSQL too relies on high performance disk IO to function properly. This widely known.
In this session, we'll explore how memory allocation at the container or operating system level influences the performance of buffered disk IO. We'll also examine Linux memory management details and the different ways to perform disk IO. From there, we'll walk through a number of examples that reveal the typical dynamics of cached and non-cached IOs, as well as the differences between the two.
Understanding these dynamics are important to PostgreSQL, but really to any application, that is dependent on disk IO and has performance requirements.
- Date:
- 2024 April 18 16:10 PDT
- Duration:
- 50 min
- Room:
- San Pedro
- Conference:
- Postgres Conference 2024
- Language:
- English
- Track:
- Ops
- Difficulty:
- Intermediate