Postgresql vs sql server benchmarks

broken image
broken image

The file « Benchmark test PostGreSQL.sql » contains the SQL script to create the table and populate it, and also all the queries we tested for PostGreSQL.The SQL queries to reproduce the test can be download at: we stopped the other RDBMS service while testing one.computing the average response time of the 8 remaining elapsed time.eliminating best and worst response time.PostGreSQL has a specific collation comming with the OS parameterization: SQL Server has a storage configuration as follow: ALTER SYSTEM SET max_parallel_workers_per_gather = 8

broken image