Postgresql or mariadb for large tables?

Question

MySQL

In general, a very holivar question, but still decided to ask.
For a long time I have been working with mysql to work with small data. Now there is a task for a project with a lot of data (I think so).

Generally 4 tables on ~20-30 million records are supposed. And other tables with little data. The database weighs 10GB. 8-10 million records will be added annually.

- 90% of the query to the database is a regular select, join will be used rarely (if possible)
- Insert and update by users is the minimum number, all additions and updates are performed by cron tasks
- The load on users is about 30 thousand. during the day

I don't know how fast mysql will be when working with this amount of data. Well, in fact, which would be better to choose Mysql or Postgresql?

Answer 1

It doesn't matter, either the one you already know how to "cook" (you or the team), or which one you like better.
ZY still it is possible to lift test benches and to test both according to the requirements.

Answer 2

Here everything is on the shelves...
https://developer.okta.com/blog/2019/07/19/mysql-v...
I would most likely choose MySQL... since there are few records/updates and a crown. ..
From the article:

Postgres is built with extensibility, standards compliance, scalability, and data integrity in mind - sometimes at the expense of speed. Therefore, for simple read-heavy workflows, Postgres may be a worse choice than MySQL.

Answer 3

20-30 million is not even close to the numbers on which the brakes will be felt (of course, with adequate settings and indexes) in any DBMS with a normal amount of allocated memory. Table growth is treated by partitioning old/no longer changing data.

Answer 4

I took MariaDB from the name and liked the logo. well, something that seems like an improved offshoot of Mayskuel.
I uploaded a couple of databases of 10 GB each, the main thing is to make the necessary indexes - then requests for samples fly.

Answer 5

https://habr.com/ru/company/badoo/blog/342336/
Maria or Perkona with rocksdb table engine