Conference Schedule - PGConf.EU 2022

Full Page Writes in PostgreSQL - Critical, Evil or Both - Why you should care and how to optimize

Date: 2022-10-28
Time: 09:30–10:20
Room: Berlin 2+3
Level: Intermediate

The first portion of the session will cover the critical reason why PostgreSQL generates these full page writes (FPW) and how to monitor the rate of generation. Next we will demonstrate the negative effect of full page writes on performance, scale, backups and replication. Then we will cover various techniques to decrease the amount of full page writes and improve your databases performance/scale/efficiency including using new PostgreSQL versions, parameter changes, application changes and the use of specific PostgreSQL features like partitioning. The final portion of the session will look at how future architectures can eliminate the need for full page writes.

Speaker

Grant McAlister