Choice of DB

Hi,

It's my first post to this list. I'm a little familiar with PostgreSQL from
the documentation but never used it yet in a real environment. I've used
the last 15 years Firebird as the RDBMS for our ERP application. Not bad,
it served us somehow ok, but not that great either... I've grown unhappy
with the product because of the many corrupted database we encounter at
customer sites. I have plans to rewrite the ERP application and use a new
RDBMS and create a new database from scratch. And of course the problem now
is, what RDBMS to use. I know this is not an easy question and has no
straight answer. And I certainly don't want to start a war of words of
pro's and con's of database servers. However I have to make a choice.

First of all the Uber story scared me. Seems they went from Postgres to
MySql because of several issues. But maybe issues I would never run into.
First of all, performance is certainly very important. It's said that
MariaDB outperforms "everything", but I'm not sure if that's a good choice.
It's not like we have a thousand simultanous users who are updating records
non stop. Most of our sites have between 10 and 50 users. Of course they
insert and update data, but not at a speed of xxx transactions per second.
They are simply users who enter quotes, orders, delivery notes, invoices,
projects, time registration of employees on the road, etc....

I'm wondering if PostgreSQL outperforms Firebird in client/server ERP
applications? The big thing is, sometimes large datasets are fetched, I'm
wondering if PostgreSQL would do better than firebird and if the
performance of Postgres is fine let's say compared to mysql or mariadb,
because if the performance won't be good, my boss would consider the
migration from firebird a total failure.

Thanks in advance and sorry if my question doesn't fit in with the list.

Best regards...