Re: Performance Test for PostgreSQL9

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(at)2ndquadrant(dot)com> 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(at)2ndQuadrant(dot)com Baltimore, MD
> PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us
> "PostgreSQL 9.0 High Performance": http://www.2ndQuadrant.com/books
>
>