3 ms·
Pg transactions seem more likely to deadlock compared to MySQL, IME. Its replication story was also worse for many years, though it's catching up. Pg connectio
by paulryanrogers 5y ago
Pg transactions seem more likely to deadlock compared to MySQL, IME. Its replication story was also worse for many years, though it's catching up.
Pg connection limits are also lower because of resource allocation. And lack of query hints can really hurt when Pg's planner goes sideways.
That said InnoDB's online DDL lagged Pg for quite a while. Generally feels like they're both getting better and more alike all the time.