10 reason why you should prefer PostgreSQL to
summary
Claims ten concrete reasons to prefer PostgreSQL over MySQL and demonstrates them: MyISAM silently truncates values (ate the cake), InnoDB vs MyISAM storage layout and locks, index creation that blocks writes and can force large temporary copies (one site goes 7 hours down while adding columns/indexes), WAL-based replication and point‑in‑time recovery via rsync/WAL shipping, process‑per‑connection vs threads, EXPLAIN/EXPLAIN ANALYZE and pg_stat_statements for diagnostics, and practical features like JSONB and partial/functional indexes.
AI-written summary · about
chapters (9)
- 0:00Start
- 1:17MySQL or PostgreSQL?
- 1:49Quick Comparison
- 21:16PostgreSQL-QUERY PLAN
- 22:50PostgreSQL - Complex Query
- 23:49MySQL Replication
- 24:48PostgreSQL Replication
- 27:35Functional Indexes
- 27:49JSON datatype
related talks
50mPostgreSQL Versus MySQL - Isn't a Database Just a Database
29m10 Features your Developers are missing when 'Stuck' with proprietary database!
31m#PostgreSQL to #MySQL: A DBA Perspective
51mPostgreSQL Top Ten Features
51mHow Postgres is Different (read BETTER than) your database
16mWhy PostgreSQL took the crown from MySQL and what lies ahead
34mDuel Test: PostgreSQL vs MySQL
32mTwo opensource RDBMS: mariadb vs postgresql