ToroDB scaling PostgreSQL like MongoDB
summary
Explains ToroDB, an extension that makes PostgreSQL behave more like MongoDB for horizontal scaling. Describes combining PostgreSQL with MongoDB-style document storage and transparent sharding/replication to address scaling limitations of traditional RDBMSs while keeping relational features.
AI-written summary · about
chapters (19)
- 0:00Start
- 5:44ToroDB storage Internals
- 11:10ToroDB storage and I/O savings
- 12:50ToroDB: query by structure
- 16:01Scalability?
- 17:20Ways to scale
- 17:46Vertical scalability
- 19:50Read scalability: replication
- 21:44MongoDB write acknowledge
- 22:12MongoDB's dirty and stale reads
- 25:14Replication protocol choice
- 25:32MongoDB's replication protocol
- 26:09MongoDB replication implementation
- 28:15Advantages of ToroDB w/ replication
- 29:06ToroDB: native SQL
- 30:51ToroDB native SQL
- 31:06Introducing ToroDB VIEWS
- 36:17Benchmark
- 37:26Disk usage
related talks
54mBreakout Session
01h 04mToroDB: NoSQL & relational Java database with SQL analytics
33mToroDB Stampede: open-source BI connector for MongoDB
48mHow to Tame A Mastodon: Lessons for PostgreSQL at Scale
25mCourting Mongo, committing to Postgres: Our data love story!
52mDistributed IoT Telemetry Storage Based on PostgreSQL and TimescaleDB
24mBuilding an open-source MongoDB-compatible database on top of PostgreSQL
56mBreakout Session