Presented by:

Ce97cc5a38992847cc85da5a47944d3a

Dmitry Dolgov

Zalando SE

Software engineer at Zalando SE, involved in development and improvement of document-oriented features of PostgreSQL.

No video of the event yet, sorry!

Everyone already knows the Jsonb data type: one of PostgreSQL’s most attractive features which allows efficient work with semi-structured data without sacrificing strong consistency and ability to use all the power of proven relational technology. But what exactly is inside Jsonb, are there any caveats, and how can you accidentally bring down performance?

We will discuss all that questions altogether with advantages and disadvantages of using Jsonb in different situations in comparison with other solutions and existing standards. I'll show some important best practices we've got from our own experience, e.g. about how to write compact queries, or avoid common mistakes/performance problems.

Date:
2018 April 20 12:50 EDT
Duration:
50 min
Room:
Enterprise
Conference:
PostgresConf US 2018
Language:
English
Track:
Use Cases
Difficulty:
Medium