Schedule - PGConf.EU 2023
Tame the growth of your database
Learn how to tame the growth of your database by understanding copy-on-write and HOT updates.
PostgreSQL MVCC model is based on copy-on-write semantics. To avoid write amplification on updates PostgreSQL implements a HOT-update optimization. In this talk I will go over how copy-on-write works, how HOT updates work and how you can accidentally shoot yourself in the foot by depriving the database the ability to do HOT updates. Final example will show the default behavior of the default Django ORM that makes it very easy to accidentally prevent HOT updates.