Re: PostgreSQL vs MariaDB

Στις 24/3/23 13:07, ο/η Inzamam Shafiq έγραψε:
> 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)?
>

I would say that for small shops and simpler apps MySQL / MariaDB may be 
fine. If you go to enterprise class apps and infrastructure you'll start 
to need more, which means PostgreSQL.


For instance : unnest , transactional DDL, the extensions system, custom 
types, the MVCC etc those are very important features that some 
commercial DBs lack.



> Thanks.
>
> Regards,
>
> /Inzamam Shafiq/
> /Sr. DBA/

-- 
Achilleas Mantzios
  IT DEV - HEAD
  IT DEPT
  Dynacom Tankers Mgmt