Sample pgbench test results

These all come from the sample server and configuration described above, 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, 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 dropping 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.

SELECT-only test

This curve has a similar shape no matter what hardware you have. The only ...

Get PostgreSQL 9.0 High Performance now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.