Re: Performance Test for PostgreSQL9 - Mailing list pgsql-performance

From Greg Smith
Subject Re: Performance Test for PostgreSQL9
Date
Msg-id 4D6F12A1.5050903@2ndquadrant.com
Whole thread Raw
In response to Re: Performance Test for PostgreSQL9  (Selva manickaraja <mavles78@gmail.com>)
Responses Re: Performance Test for PostgreSQL9
List pgsql-performance
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@2ndQuadrant.com   Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support  www.2ndQuadrant.us
"PostgreSQL 9.0 High Performance": http://www.2ndQuadrant.com/books

pgsql-performance by date:

Previous
From: Andy Colson
Date:
Subject: Re: Performance trouble finding records through related records
Next
From: Adarsh Sharma
Date:
Subject: Is it require further tuning