...
Here is a quite interesting post regarding hidden costs when working with JSONB
https://heap.io/blog/engineering/when-to-avoid-jsonb-in-a-postgresql-schema
| Warning | ||
|---|---|---|
| ||
... Using the above measurements table again, the initial non-JSONB version of our table takes up 79 mb of disk space, whereas the JSONB variant takes 164 mb — more than twice as much. That is, the majority of our table contents are the the strings value_1, value_2, value_3, and scientist_id, repeated over and over again. ... |
...