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.
