Florents Tselai has submitted a new session!

Spat: Hijacking Shared Memory for a Redis-Like Experience in PostgreSQL

Databases traditionally use shared memory as a transient workspace for query execution, caching, and transaction management, hidden from direct user control. But what if we could repurpose it for user-facing, high-performance data structures and general caching?

In this session, I’ll explore PostgreSQL’s shared memory APIs available to extension developers, including recent features like the DSM Registry. I’ll introduce Spat, a Redis-like in-memory data structure server embedded within PostgreSQL, where data is stored entirely in shared memory.

Spat provides an extended key-value model in which keys are strings, and values can be strings, lists, sets, or hashes. This offers a fast, lightweight alternative for ephemeral storage inside PostgreSQL.

This talk will explore the technical challenges and opportunities of using shared memory beyond its traditional scope, providing ideas for anyone interested in extending PostgreSQL.


Open session

These notifications can be turned off on Edit event page.