r/programming • u/squareproton • Nov 16 '14
PostgreSQL vs. MS SQL Server - A comparison of two relational databases from the point of view of a data analyst
http://www.pg-versus-ms.com/
171
Upvotes
r/programming • u/squareproton • Nov 16 '14
27
u/bucknuggets Nov 16 '14
The problem is that it's more complicated than that. There are numerous scenarios in which SQL Server is "best":
SQL Server can vastly outperform & outscale Postgres. So, if your needs are to run interactive analytics on 10TB of data - SQL Server is the best.
An organization may have 10 trained SQL Server DBAs and none trained for Postgresql. If you need to decide which software is best for a new small app, odds are it will be SQL Server - just because of the human skills, processes, etc you can leverage.
A product may need a database and be run by a client. If your clients are all running windows (ex: most state & local government) then they're probably already running SQL Server - more of the same will probably be best.
An organization may be leveraging the full Microsoft technology stack, in particular around reporting. Keeping the database on SQL Server will probably be best.
Postgresql has a number of surprising areas of immaturity. For example: create OR REPLACE VIEW is mostly worthless. And bulk-loading into Postgresql lacks a good non-logged, high-speed option.
Having said that, I vastly prefer to work on Postgresql and I think it has a ton of advantages.