Using JSONB in PostgreSQL: How to Effectively Store & Index JSON Data in PostgreSQL
Scalegrid
JULY 17, 2020
Not all index types support all operator classes, so planning is needed to design your indexes based on the type of operators and queries that you plan on using. For example, find all books that are available in braille. demo=# select * from books where data ? demo=# explain analyze select * from books where data ?
Let's personalize your content