Support More Transactions on PostgreSQL Databases with N2 VM Instances
While public cloud options reduce the day-to-day headaches of dealing with
on-prem hardware, organizations still need to take hardware into account when deciding on a VM instance type for their workloads. For OLTP workloads such as databases that back e-commerce sites, the underlying hardware for VM instances is a factor that drives the number of customers and orders you can support.
Choosing VM instances enabled by 2nd Generation Intel Xeon Scalable processors could let your business support more customers.
In PostgreSQL transactional database tests comparing Google Cloud virtual machine instances, newer N2 VM instances featuring 2nd Generation Intel Xeon Scalable processors outperformed N1 VM instances with older Intel Xeon E5-v4 processors at three different instance sizes, processing up to 1.21x the transactions per minute.
When your organization is deciding on the right VM instance for OLTP databases, consider how the underlying hardware translates into better performance and better value. Regardless of the size of your databases, investing in the N2 VM instances can ensure your e-commerce site is ready to support your growing customer base.
Support More Customers on Small VM Instances
Deciding to expand resources requires balancing performance needs and cost. Whether your organization is large or small, the transactional databases that back your business need adequate resources to support peak periods and plan for future growth without slowing down. Investing in newer technology ensures you can support more customers as your business grows. Tests comparing performance of small instances with 8 vCPUs show that choosing Google Cloud N2 VM instances featuring 2nd Gen Intel Xeon Scalable processors deliver up to 1.21x the PostgreSQL transactions per minute of an N1 VM instance running on older processors.
Support More Customers on Medium VM Instances
In HammerDB tests, medium VM instances supporting mid-sized databases had similar performance gains from choosing VM instances with updated processor technology. With 16 vCPUs, Google Cloud N2 VM instances featuring 2nd Generation Intel® Xeon® Scalable processors delivered 1.20x the PostgreSQL transactions per minute of an N1 VM instance.
This means that you can meet your performance goals and/or growth needs for databases of multiple sizes by selecting Google Cloud N2 VM instances with updated 2nd Generation Intel Xeon Scalable processors.
Support More Customers on Large VM Instance
Support More Customers on Large VMHammerDB testing with large VM instances saw performance gains for Google Cloud N2 VM instances featuring 2nd Generation Intel Xeon Scalable processors compared to older N1 VM instances—handling up to 1.16x the transactions per minute.
If your organization plans to run PostgreSQL database workloads in the cloud, these results show that N2 VM instances offer better performance at multiple database sizes thanks to updated 2nd Generation Intel Xeon Scalable processor technology.