Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pg63z-0000rQ-Ub for pgsql-general@arkaria.postgresql.org; Sat, 25 Mar 2023 15:44:15 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pg63x-0006Dz-Nw for pgsql-general@arkaria.postgresql.org; Sat, 25 Mar 2023 15:44:13 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pg63x-0006Dp-DM for pgsql-general@lists.postgresql.org; Sat, 25 Mar 2023 15:44:13 +0000 Received: from cloud.gatewaynet.com ([185.90.37.94]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pg63u-0002Qm-Uf for pgsql-general@lists.postgresql.org; Sat, 25 Mar 2023 15:44:12 +0000 Content-Type: multipart/alternative; boundary="------------DPmGXI4UvBwQFa4ybABKhq2p" Message-ID: <9d55172c-ebbe-213a-7d28-3a345b0ef673@cloud.gatewaynet.com> Date: Sat, 25 Mar 2023 17:44:06 +0200 MIME-Version: 1.0 Subject: Re: PostgreSQL vs MariaDB Content-Language: en-US To: pgsql-general@lists.postgresql.org References: From: Achilleas Mantzios In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------DPmGXI4UvBwQFa4ybABKhq2p Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit Στις 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 --------------DPmGXI4UvBwQFa4ybABKhq2p Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit Στις 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
--------------DPmGXI4UvBwQFa4ybABKhq2p--