JSON vs JSONB in PostgreSQL

PostgreSQL offers two data types to store JSON information: JSON vs JSONB.

This video goes into the details of the differences between the two in terms of storage, speed of write & read, index support, edits and order of keys.

00:00 Intro
00:25 How is data stored on disk
00:58 Write Performance
01:26 Read Performance
02:10 JSONB and spaces in the payload
02:49 JSONB and key ordering
03:12 Index support
03:30 Editing a JSON object
03:58 Summary

More info at https://ftisiot.net/postgresqljson/wh...

Want to try? Check out Aiven for PostgreSQL FREE tier JSON_EXTRACT https://go.aiven.io/francesco-signup

Want to optimise your PostgreSQL SQL? Check Aiven AI Database Optimiser https://aiven.io/solutions/aiven-ai-d...