What database to use for large amount of data?

Question

Database

Good afternoon. Tell me, which database is better to use for working with large data arrays?
Now there is an old project, it is written in delphi and stores data in MSM . The
task is to create a web interface in php and, accordingly, use the new database format.
The current size of the database is over 2 GB. but records will be 5 times more. Therefore, advice is needed on which database to choose for working with such large amounts of data in order to maintain maximum performance and stability.

Answer 1

The current size of the database is over 2 GB. but records will be 5 times more.

This is a very small amount of data. Even 10 GB, even 100.
Big - from a terabyte.
Take Postgre or even MySQL.
Lol you're kidding :)

Answer 2

Is 10 GB a lot?
Start with MySQL/MariaDB, you can't go wrong. Performance depends on proper DBMS architecture and proper use of indexes.