Slide 27
Slide 27 text
Monktoberfest 2018
Postgres first received JSON support in Postgres 9.2. But the initial
JSON support in 9.2 was about JSON validation, hence itwas less
ideal for many use cases that needed italong with fast query
performance.
A couple of years later we got the the successor to the JSON
datatype: JSONB. Itis a binary version of JSON stored on disk. It
compresses, so you lose whitespace, but itcomes with some
powerful index types to allow you to work much more flexibly with
your JSON data.