How AI Is Built Supabase acquires OrioleDB, A New Database Engine for PostgreSQL | changelog 1
9 snips
Apr 17, 2024 Supabase acquired OrioleDB, a new storage engine for PostgreSQL. Oriole uses an UNDO log for efficient updates and reduced storage. It offers performance boosters like data compression and easy integration with data lakes. The podcast discusses the benefits of OrioleDB for high throughput databases and potential new use cases.
AI Snips
Chapters
Transcript
Episode notes
Undo Log Replaces Tuple-Versioning
- OrioleDB leverages Postgres table access methods to replace MVCC tuple-versioning with an undo log design.
- This stores only changes needed to revert updates, reducing storage and speeding up updates.
Immediate Updates With Short-Lived Undo Log
- OrioleDB applies updates immediately and records undo information instead of keeping full old row versions.
- The undo log is short-lived and can be trimmed as transactions finish, reducing bloat and vacuum needs.
Try It On A Copy First
- Test OrioleDB on representative copies before switching production systems to it.
- Assess whether reduced IO and faster updates outweigh less-mature testing and optimizations.