In this chapter, we will learn how to create a load test for a PostgreSQL database to benchmark PostgreSQL performance with pgbench and JMeter. The purpose of benchmarking a database is not only to check the capability of the database but also to check the behavior of a particular database against your application. Different hardware provides different results based on the benchmarking plan that you set. It is very important to isolate the server (the actual one being benchmarked) from other elements such as the servers driving the load or the servers used to collect and store performance metrics. After benchmarking, you will also get application characteristics.
With the help of a project in this chapter, we will create and run load tests to benchmark the performance of the PostgreSQL...
