Is Your PostgreSQL JSONB GIN Index Really Working? Find Out Now!
Gin indexes support the gin_trgm_ops class that can be used to index the data in jsonb. You can choose to use expression indexes to build the trigram index on a particular. Enhancing performances when querying a jsonb column in postgresql involves a combination of strategies: Using the right indexing (such as gin), exploring jsonpath. Gin indices are an extremely powerful feature in postgres, and can make it sustainable to use postgres for your product for practically all data.
But you can use the gin index if you rewrite. Postgresql uses the gin index type for indexing a column with jsonb data type. Gin stands for generalized inverted index. Note that you can utilize the gin index for tsvector. Gin indexes don't support @> all, only @>.
postgresql gin index text full search following looks shows like
