Re: Performance Test for PostgreSQL9

From: Greg Smith <greg(at)2ndquadrant(dot)com>
To: Selva manickaraja <mavles78(at)gmail(dot)com>
Cc: jd(at)commandprompt(dot)com, Robert Haas <robertmhaas(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Performance Test for PostgreSQL9
Date: 2011-03-03 04:01:37
Message-ID: 4D6F12A1.5050903@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Adarsh Sharma 2011-03-03 04:31:58 Is it require further tuning
Previous Message Andy Colson 2011-03-03 03:04:42 Re: Performance trouble finding records through related records