none
Considering Migrating from MS SQL to PostgreSQL RRS feed

  • Question

  • Hi, 

    Our management is considering of migrating their RDBMS software from MS SQL to PostgreSQL.

    I wanted to know is there any stats which shows that SQL Server is better than PostgreSQL in terms of performance, security or any other metrics?


    aa

    Wednesday, November 30, 2016 11:59 AM

All replies

  • Hello,

    In terms of performance. PostgreSQL does not offer in-memory capabilities and TPC says Microsoft SQL Server is king on performance.

    http://www.tpc.org/tpch/results/tpch_perf_results.asp?resulttype=noncluster&version=2%&currencyID=0


    PostgreSQL does not support XML.


    You won’t have SQL Server Reporting Services and Integration Services (ETL) with PostgreSQL.

    It is easier to tune queries with SQL Server tools.


    The following resource compares both DBMS too.


    http://dbadailystuff.com/2014/02/20/sql-server-vs-postgresql-fighting-for-resources-in-the-same-server/


    Hope this helps.


    Regards,

    Alberto Morillo
    SQLCoffee.com


    Wednesday, November 30, 2016 1:26 PM
    Moderator
  • You will find it difficult to get developers and administrators for PostGres. It will also be difficult to write and tune queries. The toolset simply isn't there. While you can use the slow query log on busy systems it is simply overwhelmed.

    The metrics for simple workloads may be better, but not for more complicated workloads. Postgres does not have any ratings in tpce. http://www.tpc.org/tpch/results/tpch_perf_results.asp?

    So, it is hard to do a comparison.

    Wednesday, November 30, 2016 1:38 PM
  • Our management is considering of migrating their RDBMS software from MS SQL to PostgreSQL.

    I wanted to know is there any stats which shows that SQL Server is better than PostgreSQL in terms of performance, security or any other metrics?

    I converted a mission-critical PostgreSQL database to Microsoft SQL Server several years ago and attained significantly better performance with SQL Server on similar hardware for a high-volume OLTP workload. That was before memory-optimized features were introduced in SQL Server 2014. I have no doubt judicious use of those features would have improved performance further, perhaps by orders of magnitude. In the interest of full disclosure, it was an old version of PostgreSQL and we had limited DBA and development expertise.

    Since you've asked this question in a SQL Server forum, it is likely the answers will be somewhat biased towards SQL Server. I would expect good PostgreSQL DBAs and development teams can attain a similar level of performance for general business applications as similarly skilled SQL Server teams as long as memory-optimized features are not required to achieve the required performance level.  From a management perspective, existing development and administration expertise is a major consideration. Switching DBMS products is not trivial and can be costly.


    Dan Guzman, Data Platform MVP, http://www.dbdelta.com

    Wednesday, November 30, 2016 2:01 PM