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 <be...@silentmedia.com>
*Sent:* Friday, March 24, 2023 7:08 PM
*To:* Inzamam Shafiq <inzamam.sha...@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.
