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.
This curve has a similar shape no matter what hardware you have. The only ...
Get PostgreSQL 9.0 High Performance now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
