3 ms·
I'm looking at evaluating Postgres for the data work I do at work, which would replace the (expensive) MS SQL server we are currently using. Aside from performa
by JimmyAustin 11y ago
I'm looking at evaluating Postgres for the data work I do at work, which would replace the (expensive) MS SQL server we are currently using. Aside from performance boosts from being able to throw more hardware at the problem due to lower costs, is Postgres as performant as MS SQL?
- travjones 11y agoI think that is a tough question to answer because it really depends on what you're doing with the data/database. Some queries may run faster on one RDBMS and some may run faster on another RDBMS. I would like an answer to this question as well. I did a quick search and I haven't found any modern comparisons of performance between databases, but it would be great if there was a more modern and expanded version of the SQLite comparison[0]. I can say that I use Postgres and have not been disappointed with performance and it costs me $0. I encourage you to try it out. If you're a heavy user of SSMS, then you will have to change your flow a bit to accommodate psql. However, once you get a handle of psql, it's actually a pleasure to use. [0]: https://www.sqlite.org/speed.html https://www.sqlite.org/speed.html