Schedule - PostgreSQL Development Conference 2024

Tricks from in-memory databases

Date: 2024-05-30
Time: 14:30–15:20
Room: Sauder(2270)
Level: Intermediate

In-memory databases feature some interesting performance techniques. However, some of this techniques can have limited use in Postgres too. Following topics will be discussed. 1. Pointer swizzling. Primary key lookup goes long road from B-tree pages, to IndexTuple, to tid, to buffer, to line pointer, to tuple, to datum. We can shorten this steeplechase. 2. More cache-friendly page layouts. Binary search can touch less cachelines, page can be columar-organized(PAX). 3. Optimistic buffer locking. Reading without lock, discarding result if anything was changed.


Talk recorded at https://youtu.be/lkCTX8VaKqU.

Slides

The following slides have been made available for this session:

Speaker

Andrey Borodin