Using JSONB in PostgreSQL: How to Effectively Store & Index JSON Data in PostgreSQL
Scalegrid
JULY 17, 2020
If you store each of the keys as columns, it will result in frequent DML operations – this can be difficult when your data set is large - for example, event tracking, analytics, tags, etc. Wave 1: PostgreSQL 9.2 (2012) added support for JSON data type. 2014) added support for JSONB data type. JSON database in 9.2
Let's personalize your content