This site is about a previous instance of this event. For the current event, please see the updated site.

Schedule - PGConf.EU 2017

NoSQL Best Practices for PostgreSQL

Date: 2017-10-25
Time: 12:10–13:00
Room: Baltic I
Level: Intermediate

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 about how to write compact queries to work with Jsonb and avoid common mistakes/performance problems.

Slides

The following slides have been made available for this session:

Speaker

Dmitry Dolgov