PostgreSQL JSON JSONB Making the Right Choice for Your Application
summary
PostgreSQL supports two JSON types: introduced in 9.2 JSON stores the text as-is (preserving whitespace and formatting) while binary parsed tree JSONB parses and stores a compact binary representation (uses TOAST) so writes are heavier but reads and indexing are faster. JSONB supports many operators and works with GIN or GiST indexes; beware that a GIN index on a JSON/JSONB column can grow to ~90% of the table size, so check query access patterns before indexing.
AI-written summary · about
related talks
49mShould I use JSON in PostgreSQL?
48mPostgres and Json - How to get the best of them?
35mLeveraging PostgreSQL 17's JSONB for Enhanced Data Modeling
42mNoSQL as Not Only SQL
50mUsing JSON with Postgres 9 3
25mJSON in PostgreSQL - evil data type or just needs to be tamed?
53mNoSQL Best Practices for PostgreSQL
14mJSON data structure – the hidden gem inside your database engine