Boost Database Performance with Newer R5 Instances Featuring 2nd Gen Intel® Xeon® Scalable Processors
Transactional databases are behind many important applications across all industries and businesses. From tracking inventory to backing CRM software, transactional databases are often the lifeblood of a company. When you choose cloud instances for your PostgreSQL transactional databases, make sure you’re getting the performance and value you need by choosing AWS R5 instances featuring Intel Xeon 2nd Gen Scalable processors.
These memory-optimized R5 instances offer 8 GB of memory per vCPU and range from 2 to 96 vCPUs, perfect for all transactional database needs, regardless of size. In PostgreSQL testing running a HammerDB TPROC-C workload against three sizes of AWS instances, newer R5 instances with 2nd Gen Intel Xeon Scalable processors delivered up to 1.38x the number of transactions per minute (TPM) compared to R4 instances with previous-generation Intel Xeon processors.
With more TPM, your PostgreSQL-backed applications can do more work, better support user growth, and handle peak usage periods more easily. Additionally, at the time of our testing, the R5 instances cost slightly less than the older R4 instances, meaning you could save money while gaining performance.
Better Performance for Small Databases
Databases come in all sizes and even when they don’t need a lot of hardware resources, they must still meet performance requirements. In our testing, a small database running on an 8-vCPU AWS r5.2xlarge instance featuring 2nd Gen Intel Xeon Scalable processors handled 1.38x the TPM of the same size database on an AWS r4.2xlarge instance.
Increase Medium-Sized PostgreSQL Database Transactional Performance
Should your database require more resources than the 8-vCPU instances offer, you could choose the 16-vCPU r5.4xlarge instance enabled by 2nd Gen Intel® Xeon® Scalable processors to support your PostgreSQL database and receive 1.36x the TPM of the r4.4xlarge instance.
Improve the Performance of Your Large Databases
For databases that require a lot of resources to keep your applications running smoothly, take a look at the 64-vCPU AWS r5.16xlarge instance featuring 2nd Gen Intel Xeon Scalable processors. In our PostgreSQL tests, the r5.16xlarge instance offered up to 1.32x the transactions per minute of the r4.16xlarge instance.
If your company hosts PostgreSQL databases in the cloud, invest in AWS R5 instances enabled by 2nd Gen Intel Xeon Scalable processors to get better value.