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

Summary

Benchmarking databases is a very extensive topic, and this chapter just introduces the major concepts. Having the pgbench tool bundled with the database is handy for doing smaller tests, but you need to be careful of its limitations before you rely too much on its results for your tuning efforts.

  • The basis for the built-in pgbench tests is outdated, and it's unlikely to match real-world performance. It can still be useful as a synthetic performance test.
  • You can write your own custom tests, either against the standard pgbench tables or new ones, and use the pgbench scripting capability to run those tests against multiple clients at once.
  • Only a small number of the general database settings will impact pgbench results, since its queries are ...

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