3 ms·
Postgres deficiencies you describe can be solved with elbow grease MySQL's cannot
by whateveracct 5y ago
Postgres deficiencies you describe can be solved with elbow grease
MySQL's cannot
- lmm 5y agoThat's backwards IME. MySQL has bad defaults and bad error reporting, but you can work around these things by being careful about the configuration of every instance and making sure you always use strict modes and check for errors after each statement. Postgres has generally better defaults and better behaviour upfront, but things like true (master-master) HA or particular secondary index behaviour that's needed for some high-performance workloads are just impossible.