Re: PostgreSQL vs MariaDB - Mailing list pgsql-general

P {margin-top:0;margin-bottom:0;}

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