Hacker News new | ask | show | jobs
by kayodelycaon 1044 days ago
https://www.postgresql.org/docs/current/datatype-json.html

Long story short: json is a modified text field, jsonb is a specialized binary format that can be loaded without the overhead of parsing. Only jsonb supports indexing.