O'Reilly logo

PostgreSQL 9.0 High Performance by Gregory Smith

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required