Conference Schedule - PGConf.EU 2022

Exploring Linux Memory Usage and IO Performance for PostgreSQL

Date: 2022-10-28
Time: 11:50–12:40
Room: Berlin 1
Level: Intermediate

Just like many databases, some of the key PostgreSQL operations depend on IO performance. However, a lesser known fact is that general operating system memory usage is a key factor to IO performance for buffered IO, which is what PostgreSQL uses.

This session shows and explains the drastic performance difference that identical IO patterns can have in different scenario's on linux, using easy examples that can be tested and replayed by the attendee.

The goal for this session is to give a DBA the information to understand IO behaviour on its servers.

Speaker

Frits Hoogland