Using JSONB in PostgreSQL: How to Effectively Store & Index JSON Data in PostgreSQL
Scalegrid
JULY 17, 2020
JSONB storage has some drawbacks vs. traditional columns: PostreSQL does not store column statistics for JSONB columns. JSONB storage results in a larger storage footprint. JSONB storage does not deduplicate the key names in the JSON. If that doesn’t work, the data is moved to out-of-line storage.
Let's personalize your content