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