Source: scalegrid.io
Using JSONB in PostgreSQL: How to Effectively Store and Index JSON Data inCategory: Database, Data
In this post, we are going to show you tips and techniques on how to effectively store and index JSON data in PostgreSQL. You can also check out our Working with JSON Data in PostgreSQL vs. MongoDB webinar in partnership with PostgresConf to learn more on the topic, and check out our SlideShare page to download the slides.
JSONB supports indexing the JSON data, and is very efficient at parsing and querying the JSON data.
For the purposes of this blog, when we refer to JSON support in PostgreSQL, we will refer to JSONB going forward.
For example, if you’re storing millions of instances of a particular key, it would be better storage-wise to name it “pb” instead of “publisherName”.The most efficient way to leverage JSONB in PostgreSQL is to combine columns and JSONB.
JSONB supports indexing the JSON data, and is very efficient at parsing and querying the JSON data.
For the purposes of this blog, when we refer to JSON support in PostgreSQL, we will refer to JSONB going forward.
For example, if you’re storing millions of instances of a particular key, it would be better storage-wise to name it “pb” instead of “publisherName”.The most efficient way to leverage JSONB in PostgreSQL is to combine columns and JSONB.
Related Articles
Community Partners
DevOps Careers