This site is about a previous instance of this event. For the current event, please see the updated site.

Schedule - PGConf.EU 2023

Tame the growth of your database

Date: 2023-12-14
Time: 16:00–16:50
Room: Zenit

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.


This session has been made available on:


The following slides have been made available for this session:


Adam Wolk