Both free, open-source. Different goals.
MySQL — most popular
WordPress, Joomla — all on MySQL. Simple, fast to start.
PostgreSQL — analytics & complex queries
Full SQL standard. JSON, GIS, arrays native. Analytics faster.
Benchmarks
CRUD: MySQL slightly faster. Complex JOIN: PostgreSQL 30-40% faster.