The story’s score and claims

Comments on No. 12 of 143 · Now-Next · edition of Wednesday 11 November 2026

Chris van Eijk: JSON vs. jsonb in PostgreSQL: size and speed, measured

Summary

Chris van Eijk of Now-Next measured json against jsonb on PostgreSQL 17.11 and 18.6. Table size depends on the documents: a million compact 200-byte documents took 17.8% more space as jsonb, while pretty-printed ones took 3.6% less. Across all cases the range ran from 22.6% smaller to 40.9% larger. Reading one key with ->> was 2.7 to 10.6 times faster from jsonb. Only jsonb supports equality and GIN indexing. The figures come from one machine and the author's own scripts. He could not reproduce a published 26% saving.

Comments

Ranked by a public rubric, not by votes: what a comment adds counts, not who wrote it. How comments are ranked · Comment rules