Sample pgbench test results

The sample test results all come from the sample server and configuration described previously, and are the sort of graph that you get from pgbench-tools each time it is run. These results were all created using PostgreSQL 9.0 and later, allowing up to four pgbench worker threads (one per core).

Select-only test

When running the simple read-only test, results will be very good while the database fits in RAM, then drop off fast after that. Note that the straight line you'll see on all these graphs is always the database size value, which is in units shown by the right axis scale:

This curve has a similar shape no matter what hardware you have. The only thing that changes is where the two big...