Company
Date Published
Author
Paul Copplestone
Word count
695
Language
English
Hacker News points
31

Summary

PostgreSQL's pluggable storage allows developers to use different storage engines for different tables within the same database, enabling optimized performance for specific workloads. The technology has been introduced in PostgreSQL 12 with initial support for ZHeap, but current progress has stalled due to limitations in the table access method API. Despite this, several initiatives are underway, including community updates and upstreaming code from OrioleDB, which aims to bring pluggable storage to the Postgres core. With ambitious timelines, pluggable storage could land in PostgreSQL 17, making it an even more attractive option for developers.