Why we should choose PostgreSQL over MSSQL

Ck Nitin

4y1.5kDatabases & DBA

Can you please help me to know the answer of this question "Why we should choose PostgreSQL over MSSQL"

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Mahesh Chand4y ago
Accepted answer
If you compare features, advancements, tooling, MS SQL Server is a better choice.
But you need to pay thousands of dollars each year in licensing. If you run a large website that needs several licenses, it can cost tens of thousands of dollars or more if you want SQL Server Enterprise.

PostgeSQL is 100% free. You can run as many as database instances, cost is $0. That is the key benefit. Most businesses are making this move from MS SQL to PostgreSQL because of the cost.

Here is a detailed comparision feature by feature.

https://learnsql.com/blog/ms-sql-vs-postgresql/
Sachin Singh4y ago
Its not like you should use one over another. You are simply saying PostgreSQL is better than MSSQL , this is incorrect.
Both can be installed on any OS.MSSQL has many advanced options, such as compression, partitioning, and optimized storage. Its data management – requiring minimal troubleshooting and with data recovery support in case of data corruption – are very useful.

The main difference is the licensing and support costs.
For MSSQL the licensing and support costs are discouraging for the e-commerce users . The advanced features tend to be very expensive.
PostgreSQL is an open-source RDBMS. There is no licensing cost for owning and upgrading it.
Muhammad Imran Ansari4y ago
There are lot of comparison on WHY question. Below are the some main comparisons:

In Terms of licencing:
PostgreSQL is Free and open source relational database management system, maintained by PostgreSQL. SQL Server is Commercial database management system, built and maintained by Microsoft.

Supported Server Operating Systems:
PostgreSQL seems to be more universal. It is widely available on multiple operating systems: FreeBSD, HP-UX, Linux, NetBSD, OpenBSD, OS X, Solaris, Unix, Windows.
SQL Server is limited to Windows, and recently Linux.

For more comparisons, read the following nice article on this:
https://tableplus.com/blog/2018/10/postgresql-vs-sql-server-database-comparison.html
Uttam Kumar4y ago
There are plenty of articles on the internet but I found this one very content full

https://www.enterprisedb.com/blog/microsoft-sql-server-mssql-vs-postgresql-comparison-details-what-differences

I hope this might help you understand as well .. Cheers!