PostgreSQL JSON Indexing

Опубликовано: 26 Февраль 2025
на канале: Vlad Mihalcea
442
43

In this video, I'm showing you what options you have to index JSON columns when using PostgreSQL.

I explain how to index logical conditions that check for the existence of a given JSON attribute, as well as if a given key/value pair is contained withing the JSON object.

Next, I will explain how GIN indexes work and the difference between json_ops and json_path_ops operators.