PostGreSQL vs Microsoft SQL Server – Comparison part 2 : COUNT performances

This second paper compares PostGreSQL and SQL Server and point out the differences in terms of performances for queries that needs to COUNT.

Our 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