Writing a storage engine for Postgres: an in-memory Table Access Method
With Postgres 12,
released in 2019, it became possible to swap out Postgres's storage
engine.
This is a feature MySQL has supported for a long time. There are at
least 8 different built-in
engines you can pick from. MyRocks, MySQL on
RocksDB, is another popular third-party distribution.
I assume there will be a renaissance of Postgres storage engines. To
date, the efforts are
nascent. OrioleDB and Citus
Columnar
are two promising third-party table access methods being actively
developed.
Why alt...
Read more at notes.eatonphil.com