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 1pfxdG-0002Fh-BC for pgsql-general@arkaria.postgresql.org; Sat, 25 Mar 2023 06:44:06 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pfxdE-0000kw-5u for pgsql-general@arkaria.postgresql.org; Sat, 25 Mar 2023 06:44:04 +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 1pfxdD-0000km-LL for pgsql-general@lists.postgresql.org; Sat, 25 Mar 2023 06:44:03 +0000 Received: from mail-yw1-x112c.google.com ([2607:f8b0:4864:20::112c]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1pfxd7-0004Wz-0J for pgsql-general@lists.postgresql.org; Sat, 25 Mar 2023 06:44:02 +0000 Received: by mail-yw1-x112c.google.com with SMTP id 00721157ae682-544f7c176easo73256977b3.9 for ; Fri, 24 Mar 2023 23:43:56 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; t=1679726635; h=in-reply-to:from:content-language:references:to:subject:user-agent :mime-version:date:message-id:from:to:cc:subject:date:message-id :reply-to; bh=cdA40TmvT1XADCnTUuFxgcrdXahE781lADG6r9OBzCc=; b=kfQQ7J1egpW2Q/8hMxY3B396KxF2/GR+f52KQU9/S9FHeDKSI5DEsN4q+XNsANMZl0 dZCevt/slmmdSG2Eixyr/aEYjl8N6azXZOnUQ4SyNAREyUNKhGFjahL4jfatodODbcf9 2e+6+Jv8tZOQ7D8riIsN0KwdVXQuoiIRcHQQS8UroIQRfqmfZM6nmPfzpp+nJH67nZiG zjAsyHlTZYdboQc+ZtTOGNpZxn4Al6eKr0Za6nlpyHR2Hb5nLkLwYqdYgHgI/lOAXUNb jA/7MlNlo12XXH42GElvu5hhoxIfHLjOfHpzhiFx4uBbv++58qOEHjwgOyYHyrlSJx3h Ee3w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; t=1679726635; h=in-reply-to:from:content-language:references:to:subject:user-agent :mime-version:date:message-id:x-gm-message-state:from:to:cc:subject :date:message-id:reply-to; bh=cdA40TmvT1XADCnTUuFxgcrdXahE781lADG6r9OBzCc=; b=SFRJ+2fz5vaHfeeeE1sMjhN2GiCt3o9rusvcJDPlICGlSciMje8nVS4bevyPDcPoFv fWiAHnTqr0RnxiC+M5bNMOcwlWUXRduKGGufQJQxE+baZ6kgy9BB0Ftz2wXMjmhf/T8l 4A2OeKEZIEHJO+2obR8QogN5Aw6Ua/rYCC3psKMo/xb3Al659+g3ff4P4bArYSBdDT4B kR8FA6LwM7nN4DBej/ukxzTWlXm4MvkddpbAm5P0OsU/LDpmRFZ4DQgzZw6aG+m4Uc1q qv6+zLDsLLFHo/MsHK3zz/gxhEUlLZSVilcJcpQB6z+HOL98qFsjr3StrVJNQ0mH6zy4 LtyA== X-Gm-Message-State: AAQBX9ev9V4l6edChttJ3CzrYO1l2X3JM83lbOaDzwo4sTw0Is6NpPTZ qK5L+Cbh/Q2zLvrB2OUZhaGqgMR2UxI= X-Google-Smtp-Source: AKy350YX7DLDbe8oUq0Rw61rQNLJtcrnKQJgZn4XWnsO6UxPYivGrhF9wEG6zHyWjSyXgsegbiU+Eg== X-Received: by 2002:a0d:cc50:0:b0:544:cbd3:76fb with SMTP id o77-20020a0dcc50000000b00544cbd376fbmr5093339ywd.27.1679726635256; Fri, 24 Mar 2023 23:43:55 -0700 (PDT) Received: from ?IPV6:2600:1700:bd2c:b810:7c4b:cdaf:5340:7843? ([2600:1700:bd2c:b810:7c4b:cdaf:5340:7843]) by smtp.googlemail.com with ESMTPSA id 80-20020a810853000000b00545a0818497sm840385ywi.39.2023.03.24.23.43.54 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Fri, 24 Mar 2023 23:43:54 -0700 (PDT) Content-Type: multipart/alternative; boundary="------------hPwAX2oZx13uW9hVfBkO84uz" Message-ID: <52500459-1fec-d0ef-1e04-d053e4ee1a29@gmail.com> Date: Sat, 25 Mar 2023 01:43:54 -0500 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.8.0 Subject: Re: PostgreSQL vs MariaDB To: pgsql-general@lists.postgresql.org References: <1903ad0e-e803-c44a-c4e9-46230c19721d@silentmedia.com> Content-Language: en-US From: Ron 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. --------------hPwAX2oZx13uW9hVfBkO84uz Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit What RDBMS is your data currently on? On 3/25/23 01:15, Inzamam Shafiq wrote: > Hi Ben, > > We have a complex running, and we will be having a lot of Insert, update > and deletes. We have many partitioned tables with huge data and some > complex SQL is written at the application logic, some analytical > functions, union/intersect etc. clauses and also we have materialized > views used at the DB level. There are some triggers and complex procedures > as well. > > Regards, > > /Inzamam Shafiq/ > /Sr. DBA/ > ---------------------------------------------------------------------------- > *From:* Ben Chobot > *Sent:* Friday, March 24, 2023 7:08 PM > *To:* Inzamam Shafiq > *Cc:* pgsql-general@lists.postgresql.org > *Subject:* Re: PostgreSQL vs MariaDB > 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. -- Born in Arizona, moved to Babylonia. --------------hPwAX2oZx13uW9hVfBkO84uz Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit What RDBMS is your data currently on?

On 3/25/23 01:15, Inzamam Shafiq wrote:
Hi Ben,

We have a complex running, and we will be having a lot of Insert, update and deletes. We have many partitioned tables with huge data and some complex SQL is written at the application logic, some analytical functions, union/intersect etc. clauses and also we have materialized views used at the DB level. There are some triggers and complex procedures as well.

Regards,

Inzamam Shafiq
Sr. DBA

From: Ben Chobot <bench@silentmedia.com>
Sent: Friday, March 24, 2023 7:08 PM
To: Inzamam Shafiq <inzamam.shafiq@hotmail.com>
Cc: pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
Subject: Re: PostgreSQL vs MariaDB
 
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.

--
Born in Arizona, moved to Babylonia.
--------------hPwAX2oZx13uW9hVfBkO84uz--