Get the latest tech news

Writing a storage engine for Postgres: An in-memory table access method (2023)


Writing a storage engine for Postgres: an in-memory Table Access Method

OrioleDB and Citus Columnar are two promising third-party table access methods being actively developed. And Citus's columnar engine works as a foreign data wrapper or a table access method. So I did the low-tech solution and opened a file,/tmp/pgtam.log, turned off buffering on it, and added a log to every method on the TableAmRoutine struct:

Get the Android app

Or read this on Hacker News

Read more on:

Photo of Memory

Memory

Photo of Postgres

Postgres

Photo of Table Access Method

Table Access Method

Related news:

News photo

A memory safe C framework, RAII, I/O, coroutine and other concurrency primitives

News photo

Writing memory efficient C structs

News photo

A Photonic SRAM with Embedded XOR Logic for Ultra-Fast In-Memory Computing