Two opensource RDBMS: mariadb vs postgresql
summary
Compares concrete internals: MariaDB/InnoDB uses a clustered index storing rows in primary-key order, so autoincrement primary key yields sequential inserts, small secondary indexes and fast range scans; PostgreSQL uses a heap storage with MVCC and index pointers, so UUIDs and random inserts avoid page contention but cause larger indexes and more random I/O and vacuuming. Notes purge/VACUUM differences, and replication tradeoffs: statement-based vs row-based replication (lower bandwidth vs safer consistency). Gives practical consequences for reporting, concurrency and scaling.
AI-written summary · about
chapters (14)
- 0:00Intro
- 0:16To start an unstoppable war......
- 1:35B+ tree
- 8:12Table structure comparsion
- 9:28Primary Key: Mariadb
- 10:18Primary Key: Postgresql
- 11:52Mariadb: Index-organized table
- 14:00Range Scan on PK(Mariadb)
- 16:50Range Scan on PK(Postgresql)
- 21:29Unveil the update in RDBMS
- 24:07Statement-based Replication
- 24:38Block-based Replication
- 25:35Block-based vs Statement-based
- 27:36Conclusion
related talks
50mPostgreSQL Versus MySQL - Isn't a Database Just a Database
44m10 reason why you should prefer PostgreSQL to
31m#PostgreSQL to #MySQL: A DBA Perspective
34mDuel Test: PostgreSQL vs MySQL
58mDatabase High Availability
16mWhy PostgreSQL took the crown from MySQL and what lies ahead
41mMariaDB The New MySQL
47mOn the past, present and future of Open Source databases