Introduction to Application Scenarios of PostgreSQL JSON and Optimization of Shared Detoast

Jul 31, 2024 · 4 min read · Application Scenarios of JSONB PostgreSQL has two data types related to JSON: JSON and JSONB. This article introduces JSONB which is also recommended for you. Suppose that all records in a table have attributes attr1..attr10, but only some records ha...