Re: Performance Test for PostgreSQL9

[Selva manickaraja <mavles78@xxxxxxxxx>]

Thanks for the enlightenment. I will then look into other tools that help with performance testing. Is pgbench really useful? We need to produce the reports and statistics to our management as we are planning to migrate one system at a time from Informix. This is to ensure that we do not overload the database with all the systems eventually. So can pgbench help us here?

On Thu, Mar 3, 2011 at 12:01 PM, Greg Smith <greg@xxxxxxxxxxxxxxx> wrote:

Selva manickaraja wrote:

The reason I had to compile is because there are no binaries for regression tests and the documentation requires us to make-install.

The reason for that is there is little reason for users of the database to ever run those.  Most (possibly all) of the the packaged builds will run the regression tests as part of the build process.  So the odds of you finding an error with them is pretty low. 

I'm getting the impression you think that the regression tests are somehow useful for performance testing.  They aren't; they are strictly code quality tests.  The only performance testing tool that comes with the database is pgbench, which is a tricky tool to get useful test results from.

-- 
Greg Smith   2ndQuadrant US    greg@xxxxxxxxxxxxxxx   Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support  www.2ndQuadrant.us
"PostgreSQL 9.0 High Performance": http://www.2ndQuadrant.com/books