2 ms·
> Experiments have been unable to find a binary encoding that is smaller or faster than a plain text encoding Why does postgres do it then?
by dumdumchan 3y ago
> Experiments have been unable to find a binary encoding that is smaller or faster than a plain text encoding
Why does postgres do it then?
- kayodelycaon 3y agohttps://www.postgresql.org/docs/current/datatype-json.html 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.