Inzamam Shafiq schrieb am 24.03.2023 um 12:07:
Can someone please list pros and cons of MariaDB vs PostgreSQL that actually needs serious consideration while choosing the right database for large OLTP DBs (Terabytes)?
As others have pointed out, this is really hard to quantify. For large databases, I would assume that Postgres' parallel queries is a major advantage over MariaDB From a management perspective, having transactional DDL makes a lot of things easier (or more robust) I am maintaining a very high-level overview, if you are interested https://www.sql-workbench.eu/dbms_comparison.html I do not claim that this is complete or 100% accurate. And it focuses on SQL level features. Not so much on management or monitoring features which are typically a major concern in large scale databases. In the end, each database product has its quirks and problems (some more than others). I think Postgres' weakest point is the MVCC implementation. Which typically is not really a problem, but there are usage patterns where it can become a problem, especially if not dealt with properly. Thomas
