Traccar 6.4 Performance with PostgreSQL: User Experiences
We have tested it in the past. Postgres is much much slower than MySQL at handling large number of writes, which is the common Traccar usage.
Thanks for your response. I'm currently interested in knowing if the performance has improved, since I'm using Traccar with Supabase in a production environment. I will have around 5000 devices, and I really don't want to move to MySQL right now. However, I'm concerned that I might face performance issues in the future
Why dont you test it yourself and share the results with the community ?
Yes, I can definitely do that. I was just checking to see if someone had already done it. I’ll run some tests soon and get back to you
Has anyone tested the performance of Traccar 6.4 with PostgreSQL? I'm interested in hearing about real-world experiences, particularly regarding:
Query response times
Database load under heavy usage
Any optimizations or configuration tweaks that improved performance
Comparison to previous versions or other database systems
If you've implemented this setup, please share your insights and any benchmarks you may have conducted