Postgres vs Mongo
summary
Compares Postgres (JSONB, functional indexes, parallel query, TOAST and Zstd compression) against MongoDB using YCSB on 1M-record workloads with 50/50, 95/5 and write-heavy mixes, running on machines with 24 cores, 48 GB RAM and a 10 Gb switch. Finds JSONB queries often several times faster than MongoDB, Postgres sustains ~200,000 transactions/sec in some configs, and compression reduces a 60 TB dataset to ~10 TB; MongoDB wins on extremely wide 200-field rows. Notes an update bug was fixed and SQL/JSON path support is implemented. YCSB benchmark JSONB + indexes
AI-written summary · about
chapters (15)
- 0:00Introduction
- 1:13SQL origins
- 4:05Relational database problems
- 5:51NoSQL emergence
- 9:03NoSQL solutions
- 10:27Flexibility versus integrity
- 13:35JSON evolution in PostgreSQL
- 17:47SQL and NoSQL convergence
- 22:49JSON in SQL standard
- 29:10PostgreSQL JSON benefits
- 33:47PostgreSQL vs MongoDB performance
- 41:42Benchmark results
- 46:20Scaling PostgreSQL
- 48:07Why PostgreSQL wins
- 51:48Q&A
related talks
53mNoSQL Best Practices for PostgreSQL
48mThe NoSQL Way in PostgreSQL
48mPostgres and Json - How to get the best of them?
01h 00mThe Modern Database Debate: Documents, Tables, or Documents in Tables?
42mNoSQL as Not Only SQL
49mShould I use JSON in PostgreSQL?
05mPostgreSQL JSON JSONB Making the Right Choice for Your Application
14mJSON data structure – the hidden gem inside your database engine