Re:Pgagroal: High-performance connection pool for PostgreSQL
by Scarbutt on Monday November 22, 2021 @11:13AM
(#29307968)
This forum is heavily anti-other-dbs and pro-postgres so you won't get objective answers here. FWIW, at least three DBAs that know both well have told me that postgres is an operational nightmare compared to mysql.
[ Parent
| on HN ]
Re:Pgagroal: High-performance connection pool for PostgreSQL
by endisneigh on Monday November 22, 2021 @11:26AM
(#29308159)
In which ways?
Re:Pgagroal: High-performance connection pool for PostgreSQL
by Scarbutt on Monday November 22, 2021 @12:58PM
(#29309510)
Don't know the exact details but they mentioned is full of operational footguns, like using it slightly wrong can utterly tank your performance or availability. Many operations are unpredictable so is hard to know what to expect.
Another reason they mentioned is InnoDB, in particular that is the most battle-tested and well-engineered storage engine. With enormous amounts of engineering effort in hardening it for performance and for stability and operability at scale by companies like Google and Facebook.
They also like Vitess.
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.