Best performance in database with Traccar

I want a suggestion. I have 5000+ devices that update every 20 seconds on different servers. Now I want to set up on traccar. In that case which database give me best performance MySQL or PostgreSQL

Definitely MySQL database.

Thank you so much for your replay. Thank you so much to provide a response.

Hello,
Do you have any tests regarding performance with heavy load (few thousands devices)?
Does Traccar perform better with MySQL than PostgreSQL?
I am asking because reviews on different websites state that Postgres is better than MySQL in handling lots of writes.

We had a performance testing some time ago where, with same hardware, MySQL was able to handle about 6k messages per second while PostgreSQL was able to handle less than 2k messages per second.

Thanks. I will try to do some tests. If I get any relevant results I will share them here.

PS: congrats, you're doing a great job!

Hi Anton, how can I do this test? "We had a performance testing some time ago where, with same hardware, MySQL was able to handle about 6k messages per second while PostgreSQL was able to handle less than 2k messages per second.".

Specifically, how can I know how many messages per second are being processed?

You can try this script.