Understanding of Jsonb Performance by Oleg Bartunov
Jsonb is a popular data type in PostgreSQL, the default data type for many modern projects. It stores json documents in binary format, which provides users many benefits such as an effective access to a field and support of complex predicates with index support. It is important to understand what affects jsonb performance and how to avoid potential problems. We will present the results of our studies and possible ways to improve performance.