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 1pfi5j-000418-Hv for pgsql-general@arkaria.postgresql.org; Fri, 24 Mar 2023 14:08:27 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pfi5i-0002me-Ak for pgsql-general@arkaria.postgresql.org; Fri, 24 Mar 2023 14:08:26 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pfi5h-0002mU-VX for pgsql-general@lists.postgresql.org; Fri, 24 Mar 2023 14:08:25 +0000 Received: from fossa.birch.relay.mailchannels.net ([23.83.209.62]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pfi5f-0004At-Dr for pgsql-general@lists.postgresql.org; Fri, 24 Mar 2023 14:08:25 +0000 X-Sender-Id: a2hosting|x-authuser|bench@silentmedia.com Received: from relay.mailchannels.net (localhost [127.0.0.1]) by relay.mailchannels.net (Postfix) with ESMTP id 856457E1571; Fri, 24 Mar 2023 14:08:21 +0000 (UTC) Received: from mi3-ss103.a2hosting.com (unknown [127.0.0.6]) (Authenticated sender: a2hosting) by relay.mailchannels.net (Postfix) with ESMTPA id DC6137E1CA3; Fri, 24 Mar 2023 14:08:20 +0000 (UTC) ARC-Seal: i=1; s=arc-2022; d=mailchannels.net; t=1679666901; a=rsa-sha256; cv=none; b=C/R71U8ivvsZGWfv9rvZyRgS97NJdiJV82Tkc9EjVL6Al4I2CTx4dRUCnwGmrbm9OPLw8Q gSxj6kRjWtS3G8neTjtmJPLt9hJENa21xT2mjUJHRn//+sJdvzY4LfMH+UifH/zT9ewvSB YKVw9iSWswbSB6NP5snh0NA3Vf1FMxqQlEVnXomkw6Uq/V/JsjWBWyyo9FbX+PL3y5jTWM hW6H/qynwAJZl0GL3J5tBrSTRVus5uIIDZY7n6mN3/iXD3+jK2EdCkL1ILMCe49bQIQVuL w52l4V1qraA1hklQQTrnh4rV01lTfvKGy/UmB8KP0TBwfvuLSxi2M3xDypCWTw== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=mailchannels.net; s=arc-2022; t=1679666901; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:cc:mime-version:mime-version:content-type:content-type: in-reply-to:in-reply-to:references:references:dkim-signature; bh=CZWfebyOwF1BGuuGF+35NcQrlT33O7dTbAnLFd9YnGE=; b=eoIQZNRanNFNZvHH76/iVrjnqznjPKCnO/q1GBCJ02v5dQLNB87DW3oQSYeoTm2JmPBfCE TKeI7qqrOT7ZiKCeF3trFznqLFGf4XnIxtFjbTKF+pKU16p6YzJzWWLJVnheB7nfHmOG8D 5nyqCfaF2xgz0KNYrv6jCbfQKseHmqV/ORitEdqLBqC4vKDX0JYGShiNEtaM8SagmrFPV9 vTnAHWyIGJWGlHwJXhL5Zoftb/r719b7JCuh2mhgq4DmCjCBVaV8U6tS0U+WNWuodIuB59 QPu1rVuTkJA0puhnbjwH4PoBrXv1ylwcPnZOeAKXS6GxHzhyo28YktVb7/HMTQ== ARC-Authentication-Results: i=1; rspamd-c98fcbcd4-n598t; auth=pass smtp.auth=a2hosting smtp.mailfrom=bench@silentmedia.com X-Sender-Id: a2hosting|x-authuser|bench@silentmedia.com X-MC-Relay: Neutral X-MailChannels-SenderId: a2hosting|x-authuser|bench@silentmedia.com X-MailChannels-Auth-Id: a2hosting X-Daffy-Inform: 5f46935b76811eb5_1679666901317_56715169 X-MC-Loop-Signature: 1679666901317:3803515523 X-MC-Ingress-Time: 1679666901317 Received: from mi3-ss103.a2hosting.com (mi3-ss103.a2hosting.com [75.98.175.95]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384) by 100.102.66.37 (trex/6.7.2); Fri, 24 Mar 2023 14:08:21 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=silentmedia.com; s=default; h=Content-Type:In-Reply-To:MIME-Version:Date: Message-ID:From:References:Cc:To:Subject:Sender:Reply-To: Content-Transfer-Encoding:Content-ID:Content-Description:Resent-Date: Resent-From:Resent-Sender:Resent-To:Resent-Cc:Resent-Message-ID:List-Id: List-Help:List-Unsubscribe:List-Subscribe:List-Post:List-Owner:List-Archive; bh=CZWfebyOwF1BGuuGF+35NcQrlT33O7dTbAnLFd9YnGE=; b=rxeribd4jxogzX7dHFTzvvoTuQ zIEg+zKWDEWpoLmRfEnNfR6qH3BGNMnPGrdMfniNbrewsiVjTzpp7uhdS3X9Ip/w2X5h9q9WG7NAt oD7cC8EzJV9c0B2l8GnSyQ2XHeL4/R2tWdnE/qlquGakCm2oX22F+QkhhC5AlFdfn32Nw1VfQuc/+ UufiprS6AwPICzoub8Tef/2Z7e5u1BMsnym+3da6+4K31KnnFbRWJ2w19K65jwYCxHPM3ziT4UJRc dao/BklJNUbSjjL0UjShMCK/cax2k8hT7VM0D1TUlLjYevALZxj9xhk3yAA4u9QEy46HMgeQaY0nN 98kBvUgA==; Received: from [97.113.156.185] (port=55624 helo=simplicity.local) by mi3-ss103.a2hosting.com with esmtpsa (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1pfi5c-00A8UN-1R; Fri, 24 Mar 2023 10:08:20 -0400 Subject: Re: PostgreSQL vs MariaDB To: Inzamam Shafiq Cc: "pgsql-general@lists.postgresql.org" References: From: Ben Chobot Message-ID: <1903ad0e-e803-c44a-c4e9-46230c19721d@silentmedia.com> Date: Fri, 24 Mar 2023 07:08:18 -0700 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.16; rv:52.0) Gecko/20100101 PostboxApp/7.0.59 MIME-Version: 1.0 In-Reply-To: Content-Type: multipart/alternative; boundary="------------7B08235E266B86CDD93F1317" Content-Language: en-US X-AuthUser: bench@silentmedia.com 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. --------------7B08235E266B86CDD93F1317 Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: 8bit 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. --------------7B08235E266B86CDD93F1317 Content-Type: text/html; charset=windows-1252 Content-Transfer-Encoding: 8bit
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.
--------------7B08235E266B86CDD93F1317--