Schedule - Nordic PGDay 2023

Fighting write amplification by stimulating HOT updates through the fill factor

Date: 2023-03-21
Time: 10:20–11:10
Room: Auditorium

We can mitigate a lot of the write amplification effects on PostgreSQL by setting a lower fill factor for tables and stimulate the amount of HOT Updates.

Before setting the fill factor we have to understand the underlying mechanisms for updates, HOT updates, single page clean up and vacuum.

When we understand the technical processes we can start tuning, monitoring and adjusting the fill factor.

The effects on our systems were more than significant and I hope you can have the same results!


Derk van Veen