Re: PostgreSQL vs MariaDB

[Ben Chobot <bench@xxxxxxxxxxxxxxx>]

Inzamam Shafiq wrote on 3/24/23 4:07 AM:

Hi Team,

Hope you are doing well.

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)?

That's a very broad question, which will take far more effort to answer than most people are willing to provide.

I would suggest describing your specific use case and asking how well PostgreSQL will fit it. You clearly have a lot of data, for example, so is that distributed across many tables? Large blobs or lots of rows? Lots of inserts? Reads? Updates? Those sorts of things.

Maybe somebody on this PostgreSQL list might even know MariaDB well enough to compare and contrast the two for you.