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.

Jsonb is popular data type in postgres and there is demand from users to improve its performance. In particular, we want to optimise a typical pattern of using jsonb as a storage for relatively short metadata and big blobs, which is currently highly inefficient.

Full-Text Search ( FTS ) is a search for the documents, which satisfy query and, optionally, return them in some order. The most usual case is to find documents containing all query terms and return them in order of their similarity to the query.

PostgreSQL 12 introduced a jsonpath - the query language for json, which is an important part of SQL/JSON specification in SQL-2016 standard. Jsonpath is a flexible way to specify the parts of json to be used for processing in functions and operators.

PostgreSQL is the first relational database which recognized the need of non-atomic data types to support developers of applications from science to Web. Jsonb in Postgres is the attractive feature for modern application developers, who want to work with json documents without sacrificing a strong consistency and ability to use all the power of proven relational technology.