Top.Mail.Ru
Jsonb in PostgreSQL and NoSQL trend: comparison and performance (Dmitry Dolgov) | PgConf.Russia 2016 | PGConf.Russia

title

text

Dmitry Dolgov
Dmitry Dolgov Zalando SE
15:00 04 February
45 min

Jsonb in PostgreSQL and NoSQL trend: comparison and performance

Schema-less is definitely a trend in the data storage nowadays, and it's not only about NoSQL, but also about traditional RDBMS. Many relational databases (e.g. PostgreSQL, Oracle, db2, Mysql) allow to storing data in the schema-less json format and use their own more or less unique way to do that.

This talk contains two parts:

  • Comparison of the json support in PostgreSQL and different relational databases, namely Mysql, Oracle, db2, MSSql in terms of supported features, functions and so on.
  • Performance benchmarks for databases with the advanced json support, namely PostgreSQL and Mysql, and the MongoDB on different workload types and configurations.

Slides

Video

Other talks