© 2026 Hashnode
Application Scenarios of JSONB PostgreSQL has two data types related to JSON: JSON and JSONB. This article introduces JSONB which is also recommended for you. Suppose that all records in a table have attributes attr1..attr10, but only some records ha...

JSON is one of the most popular human-readable data formats. PostgreSQL allows you to store JSON data and perform queries on it thanks to the json and jsonb data types. The introduction of these JSON data types represented a game changing moment for ...

Context Following my Purrsuit of optimization method a few days ago I noticed a very slow api on New Relic at , it was our one of the slowest due as per the time taken by the database transcations in it, with an avg response time of just above 3.5s a...
