- MySQL performs a bit better when reading by primary key
- Postgres performs a bit better when doing random inserts/updates.
- MySQL you don't need to worry about vacuums
- The MySQL query optimizer is nice because you can give it hints when it misbehaves. This can be a godsend during certain production incidents.
- Last I checked MySQL still has a nicer scaling story than postgres, but I'm not sure what the latest here is.
- Connection pooling is still heavily in MySQLs favor i.e. you don't need the PG bouncer for lots for scenarios.
- MySQL performs a bit better when reading by primary key
- Postgres performs a bit better when doing random inserts/updates.
- MySQL you don't need to worry about vacuums
- The MySQL query optimizer is nice because you can give it hints when it misbehaves. This can be a godsend during certain production incidents.
- Last I checked MySQL still has a nicer scaling story than postgres, but I'm not sure what the latest here is.
- Connection pooling is still heavily in MySQLs favor i.e. you don't need the PG bouncer for lots for scenarios.