Re: PostgreSQL vs MariaDB

Ben Chobot <bench@silentmedia.com>

From: Ben Chobot <bench@silentmedia.com>
To: Inzamam Shafiq <inzamam.shafiq@hotmail.com>
Cc: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Date: 2023-03-24T14:08:18Z
Lists: pgsql-general
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.