On Fri, Mar 24, 2023 at 4:07 AM Inzamam Shafiq <inzamam.shafiq@xxxxxxxxxxx> wrote: > > 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)? Think about what you want/need from the database for your project and then see which engine best satisfies those requirements. All modern RDBMS engines can handle terabytes of data. Relatively static data (mostly reads) or heavy insert will be fine with either. With large databases, UPDATEs and DELETEs may require more maintenance with Postgres in the form of tweaking autovacuum settings. https://www.sql-workbench.eu/dbms_comparison.html For a basic comparison of Postgres vs MariaDB, just uncheck all the other engines at the top. Go down the list of rows, especially the ones where only one of the two support a feature. If you don't know what a feature does or what use cases it would be for, this would provide an excellent opportunity to become better acquainted with it. For example, if you end up needing bitemporal temporal table support out of the box, go with MariaDB. On the other hand if you want the most flexibility in data types and modeling your data, Postgres is going to win out. * Transactional DDL * Clustered indexes * DDL event triggers * Alter table used in a view Go down the list. What do you need? What do you think you'll need? What would be nice to have? Do you want to host it yourself or go to one of the cloud providers for a fully managed option? If self-hosted, use whatever you like. Hack it to your specs. If managed in the cloud, Postgres and MySQL are more commonly available than MariaDB, but worth checking out ahead of time. Cheers, Miles
