PostgreSQL is the most advanced open source database, hence, PostgreSQL performance should be the first option to evaluate.
Developers benchmark a PostgreSQL database so that they can check the capability and behavior of the database against their application. Based on the benchmarking plan, different hardware can yield different results. It is very important to separate the benchmarked database server from other servers, such as the servers generating the load or the servers collecting performance metrics. As a part of the benchmarking results, developers will obtain application characteristics, such as the following:
- Is the application read/write-intensive?
- How is the read/write split (60:40)?
- How large is the dataset?
- Is the data and structure representative of the actual production database?
