- Community aggregator
- Country: United States
JSONB at Scale: Taming PostgreSQL TOAST Churn and WAL Bloat on High-Write Workloads
Originally published on tamiz.pro . JSONB is one of PostgreSQL's most useful data types for semi-structured data, but it also hides one of the database's most expensive internal mechanisms. Large documents are moved out of the main heap into TOAST storage, compressed along the way, and—when the row…