Why PostgreSQL Beats MySQL in High‑Performance Scenarios

This article compares PostgreSQL and MySQL across architecture, indexing, query optimization, data types, concurrency control, and real‑world benchmarks, showing why PostgreSQL generally outperforms MySQL in high‑throughput, complex‑query, and data‑intensive applications.

Data TypesDatabase PerformancePostgreSQL

0 likes · 12 min read

Why PostgreSQL Beats MySQL in High‑Performance Scenarios

Aikesheng Open Source Community

Jun 19, 2019 · Databases

Understanding MySQL Isolation Levels, Locks, and Gap Locking

This article explains the purpose and types of MySQL isolation levels, how they balance concurrency and consistency, details the concepts of record, gap, and next‑key locks, and demonstrates their behavior through multiple transaction scenarios with code examples.

Gap LocksIsolation Levelsmysql

0 likes · 19 min read

Understanding MySQL Isolation Levels, Locks, and Gap Locking