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...
