Vol. I · A Postgres Handbook

The Query & the Schema

A reading-room reference for writing PostgreSQL by hand — selects to window functions, with the schema in plain view.

AdvancedAdvanced PostgreSQL

Theory: PostgreSQL vs MySQL - Concurrency

The query

SQL
-- Q: How do MySQL and PostgreSQL compare in concurrency?
-- A: PostgreSQL handles highly concurrent write operations better due to its 
-- implementation of MVCC and process-per-connection architecture. 
-- MySQL (InnoDB) also uses MVCC, but PostgreSQL's locking mechanism 
-- is generally more granular and less prone to deadlocks in complex schemas.
Tested against PostgreSQL 16

Note

“PostgreSQL creates a new OS process for each connection, making it memory-heavy but highly stable.