AMD EPYC Seeing Nice Performance Improvements With PostgreSQL On Linux 5.11

Written by Michael Larabel in AMD on 21 December 2020 at 09:24 AM EST. 5 Comments
AMD
For those running PostgreSQL database servers (and potentially similar workloads) on AMD EPYC servers, Linux 5.11 is bringing a very nice Christmas gift in the form of better performance for at least some 2P server configurations.

We are just half-way through the Linux 5.11 merge window with new code continuing to land, but already I've been running Linux 5.11 Git benchmarks on a number of systems in looking for any prominent performance improvements as a result of the new feature code or any signs of performance regressions... One area where I am seeing definite improvement with Linux 5.11 is on the PostgreSQL database server performance for at least AMD EPYC 2P servers.


I am still running more tests and in varying configurations, but for cases like EPYC 7F62 2P and EPYC 7742 2P with speedy NVMe SSD drives, I have been seeing nice uplift from PostgreSQL on Linux 5.11. I haven't yet bisected the cause to see if it's some improvement with the block layer or underlying file-system with Linux 5.11 or quite possibly coming as a result of scheduler improvements and the other changes that cycle so far like the Schedutil work for AMD frequency invariance as one possibility that comes to mind.
EPYC 7F72 2P Linux 5.11

In any case, there is some nice PostgreSQL uplift being seen on Linux 5.11 from my preliminary testing. Here are some of the numbers when using an AMD EPYC 7F72 2P setup with a WD_BLACK SN850 NVMe SSD:
EPYC 7F72 2P Linux 5.11

EPYC 7F72 2P Linux 5.11

Seeing better throughput...
EPYC 7F72 2P Linux 5.11

And better latency with AMD EPYC PostgreSQL on Linux 5.11.
EPYC 7F72 2P Linux 5.11

EPYC 7F72 2P Linux 5.11

EPYC 7F72 2P Linux 5.11

EPYC 7F72 2P Linux 5.11

EPYC 7F72 2P Linux 5.11

EPYC 7F72 2P Linux 5.11

I didn't see similar uplift out of MySQL/MariaDB but those numbers were flat. Outside of database workloads, the Linux 5.10 vs. 5.11 numbers were largely flat but I am ramping up testing as the new feature material settles down. I'm continuing to explore the AMD EPYC (and Intel Xeon) performance on Linux 5.11 especially once the merge window has passed. I'll be running many Linux 5.11 benchmarks through the holidays, so stay tuned.
Related News
About The Author
Michael Larabel

Michael Larabel is the principal author of Phoronix.com and founded the site in 2004 with a focus on enriching the Linux hardware experience. Michael has written more than 20,000 articles covering the state of Linux hardware support, Linux performance, graphics drivers, and other topics. Michael is also the lead developer of the Phoronix Test Suite, Phoromatic, and OpenBenchmarking.org automated benchmarking software. He can be followed via Twitter, LinkedIn, or contacted via MichaelLarabel.com.

Popular News This Week