PostgreSQL's TableAM (Table Access Method) is extremely powerful, but there are few examples that can be used to learn about them and build your own.
MemoryAM is a simplified TableAM implementation that provides its own (simple) MVCC and is meant to help others as they explore further into the PostgreSQL extension ecosystem.
Show HN: MemoryAM – In Memory TableAM for PostgreSQL | Heykuki News