News for hackers. Stuff that matters.
Re:Pgagroal: High-performance connection pool for PostgreSQL by paulryanrogers on Tuesday November 23, 2021 @12:29AM (#29314891)
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.

There are no comments on this comment yet.