Which database to choose Mysql or Postgres?

Question

MySQL

Good afternoon.
I have a program for collecting statistical data, which saves them to the database in MYsql format.
It is planned that the database will have 100-200 million lines and it will take 200-300Gb or a little more.
Will there be a difference in performance given that I have a Samsung 850 SSD.
I will make large queries across the entire database for research.

Answer 1

Here the answers were that mysql held 400 million rows. The sheer number of rows isn't much of a factor.
In your case, I would choose mysql because the question does not show the bonuses that PostgreSQL will give, such as JSON search (mysql has it in the latest versions), LIMIT in subqueries, normal full-text search, and other features. Although Postgres is a great thing, but you would have to install something like pgtune to customize it out of the box, for some this may become an additional complexity.

Answer 2

https://www.timescale.com/

Answer 3

Will there be a performance difference

Depends on requests, in general both bases are not suitable for statistics.

Answer 4

No one (in your mind) will tell you that PG or MySQL is better for your task (as you put it).
In general, they are about the same.
The difference may arise in queries with n + 3 JOINs and with a professionally tuned structure (it is not known in whose favor).
PG is on the hype right now, you can try it. MySQL has a larger community and no quirks like "we are for professionals", they will rather tell you.
It seems yes, but so far the community is rather weak. Perhaps this is the most promising option for analysis (if this is not a marketing bullshit from Yasha, it is difficult to evaluate at the moment)