PostGreSQL vs Microsoft SQL Server – Comparison part 1 : DBA command performances

This first paper speaks about some comparisons between PostGreSQL and SQL Server in pointing out the differences in terms of performances of somes administrative queries that’s ordinary DBA needs to execute.

Our test material is a HP Z840 workstation with:

2 sockets (Intel Xeon E5-2680 v3); 128 Gb of RAM; OS Windows 10 Enterprise.

The RDBMS are:

SQL Server 2019 Developper’s edition; PostGreSQL v 13.1 community edition.

The client applications used for testing are:

SQL Server management Studio v 18.5 (for SQL Server); PGadmin 4 v 4.29 (for PostGreSQL).

Configuration of RDBMS:

SQL Server has no particular configuration. The server