Schedule - PGConf.DE 2024
Calculating the future: how to model PostgreSQL performance
Date: 2024-04-12
Time: 10:25–11:10
Room: Ballsaal 2
Level: Advanced
Feedback: Leave feedback
A long time ago in a galaxy far, far away, a group of adventures went into a deep dark cave on a distant planet to find a famous Prophet and ask him Important Questions. The Prophet listened, took some time, then answered that their database is going to do 3k IOPS.
While still mostly in the area of science fiction, the idea of predicting how the database is going to behave under certain conditions is very attractive. In this talk we discuss possible approaches for modelling, taking a simplified PostgreSQL index under a load as an example -- and try to simulate and verify the resulting IO profile. This journey will bring us to many places, going as high as building a mathematical model, and as low as figuring out how BTree page split is working.