JSON vs JSONB in PostgreSQL

preview_player
Показать описание
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

Рекомендации по теме
Комментарии
Автор

How to get the difference between 2 json data in the postgres

SiddharthaSankarTripathy
Автор

How can I apply filter on jsonb data type column

shreyajaiswal
Автор

You are cute and smart, thank you for your video, I understood 👍

drug_v_sochi