Presented by:

Ef533d5ad1a803c04c522ea834c78052

Frits Hoogland

ServiceNow

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.

No video of the event yet, sorry!

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 Carlos
Conference:
Postgres Conference 2024
Language:
English
Track:
Ops
Difficulty:
Intermediate