|
|
|
|
|
by throwawaythekey
567 days ago
|
|
A few other things I would add: - 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. |
|