Using JSONB in PostgreSQL: How to Effectively Store & Index JSON Data in PostgreSQL
Scalegrid
JULY 17, 2020
JSONB supports indexing the JSON data, and is very efficient at parsing and querying the JSON data. 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. It is a decomposed binary format to store JSON.
Let's personalize your content