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

Schedule - PGConf.EU 2023

Explaining the PostgreSQL concurrency control mechanisms using rollercoasters

Date: 2023-12-13
Time: 15:00–15:50
Room: Zenit

Understanding how PostgreSQL handles multiple requests at the same time is one of the most important concepts when working with it. Without understanding this the Multi Version Concurrency Control (MVCC) mechanisms it is hard, if not impossible, to understand and predict how an application will behave.

In this visually attractive presentation I will slowly build a great understanding about this key database concept with the help of rollercoasters. At the end of the presentation you will have a good understanding on what data is visible to what user and why. In order to build your understanding I will guide you through topics as ACID, locking, transaction space, transaction wrap around, freezing and isolation levels. This might sound like complicated but it is all very logical and perfectly understandable for all developers and DBA's.


This session has been made available on:


The following slides have been made available for this session:


Derk van Veen