CENTOS VS UBUNTU SOFTWARE

I assumed that such a difference was caused by the Linux software RAID overhead, so I did three more TCP-B benchmarks for 100 concurrent clients, this time without software RAID: I was positively surprised by FreeBSD 11.1 which was more than twice as fast as the best performing Linux, despite the fact that FreeBSD used ZFS which is a copy-on-write file system. Among the GNU/Linux distributions, Centos 7.4 was the best performer, while Debian 9.2 was slowest. Unfortunately I did not find out what caused such a mediocre FreeBSD performance.Ī more realistic image of PostgreSQL performance were provided by read write (TCP-B) benchmark. The best peforming OS in read only benchmark was openSUSE 42.3, while FreeBSD was about 40% slower. The benchmark had shown that the difference between various GNU/Linux distributions is not very significant. In this article, you will learn how Rocky Linux stacks up against CentOS and whether it truly is a great CentOS alternative. It has been widely touted as one of the best replacements for CentOS. During the test, I gradually increased the number of cuncurrent clients accessing the database. Introduction Rocky Linux is a relatively new, free and open-source operating system based on the RHEL source code. Before each read write benchmark, pgbench tables were vacuumed (the -v flag was used). The test script consisted of three parts: vacuum + warmup, read only benchmark and read write benchmark. The pgbench program version 10.1 running on a separate FreeBSD 11.1 machine was used to generate the load.

200GiB TCP-B: read write, the dataset fits into the PostgreSQL cache.

32GiB TCP-B: read write, the dataset does not fit into the PostgreSQL cache.

CENTOS VS UBUNTU INSTALL

It has more than ten thousand packages that you can easily install on your desktop.

200GiB read only: read only test, the dataset fits into the PostgreSQL cache Ubuntu has an edge over CentOS in software availability. According to the StackShare community, Ubuntu has a broader approval, being mentioned in 1870 company stacks & 1753 developers stacks compared to Centos.

32GiB read only: read only test (only selects, without data modifications), the dataset does not fit into the PostgreSQL cache.

I was interested in these benchmark combinations: ( ): Intel Xeon E5-1650 v3, 6 cores, 12 threads, 256GB DDR4 ECC RAM, 2 x 480 GB SATA 6 Gb/s Data Center Series SSD, was used as PostgreSQL server.( ): Intel i7-6700, 4 cores, 8 threads, 32GB DDR4 RAM, was used for generating SQL queries using pgbench.

The test infrastructure consisted of two dedicated servers connected with a 1 Gbit/s network:

Centos vs ubuntu