JSON performance – PostgreSQL vs MongoDB | Webinar | Umair Shahid (Stormatics)

MongoDB’s claim to fame is its exceptional ability to handle unstructured data and scale horizontally. PostgreSQL is a traditional relational database, very popular with application developers, and comes with increasing native ability to handle unstructured data.

This talk aims to benchmark and compare performance in handling JSON data between the two databases.

About thе Speaker

UMAIR SHAHID - Founder, Stormatics

Umair is a 20-year veteran of the PostgreSQL community with a passion for solving real-world problems with technology. He actively advocates for PostgreSQL around the world, speaking at conferences, organizing events, and leading local user groups. Umair is the founder of Stormatics – a professional services company with a mission to help businesses use PostgreSQL reliably for their critical data workloads. His previous experience with commercial PostgreSQL has spanned roles related to professional services and product management in major pure-play PostgreSQL organizations like EDB, 2ndQuadrant, OpenSCG, & Percona.

Register for other #onlinemeetup https://documentdatabase.org


00:00 Introduction
03:00 Popularities of databases over the 5 years
04:29 Overview of MongoDB's features
05:55 Unstructured data in PostgreSQL
07:08 Explanation of JSON
12:37 Comparing Postgres and MongoDB
17:25 Details Benchmark tool
17:40 Data structure
20:26 Explanation of a Select queries
28:57 Bulk load of both data
31:10 Introduction of the single insert benchmark
32:30 Data size on disk after ingestion
37:31 Additional insight into MongoDB's advanced features
38:08 Evaluating the handling of JSON data by the two databases.
50:24 Conclusion Q&A


What is #DocumentDatabaseCommunity ?

We are a global network of passionate developers who work in the NoSQL Document Database environment. We talk about technology challenges, assist in the emergence and development of techniques, and popularize solutions in the document database space, no matter whether they are open-source or proprietary. The goals of the DDC are to present new technologies, highlight alternatives and unite Document Database developers and users. We are just getting started but we have big plans for the future.

Subscribe to Document Database Community channel for new videos about document-oriented databases    / @docdatabasecom  

Connect with Us on Our Social Networks
Follow Open Source Renegades on Twitter:   / docdatabasecom  
Follow Open Source Renegades on LinkedIn:   / docdatabasecom