Received: from maia.hub.org (maia-3.hub.org [200.46.204.243])
	by mail.postgresql.org (Postfix) with ESMTP id D46931337BA4
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Thu,  3 Mar 2011 00:01:55 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia,
	port 10024) with ESMTP id 37707-02
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Thu,  3 Mar 2011 04:01:44 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.17.10])
	by mail.postgresql.org (Postfix) with ESMTP id BEECD1337B43
	for <pgsql-performance@postgresql.org>;
	Thu,  3 Mar 2011 00:01:43 -0400 (AST)
Received: from [192.168.1.6] (mail.highperformancepostgresql.com
	[71.179.240.8])
	by mrelayeu.kundenserver.de (node=mreu2) with ESMTP (Nemesis)
	id 0MM2cS-1Pw5fT0Sdw-008EYv; Thu, 03 Mar 2011 05:01:40 +0100
Message-ID: <4D6F12A1.5050903@2ndquadrant.com>
Date: Wed, 02 Mar 2011 23:01:37 -0500
From: Greg Smith <greg@2ndquadrant.com>
User-Agent: Thunderbird 2.0.0.24 (X11/20100317)
MIME-Version: 1.0
To: Selva manickaraja <mavles78@gmail.com>
CC: jd@commandprompt.com, Robert Haas <robertmhaas@gmail.com>,
	pgsql-performance@postgresql.org
Subject: Re: Performance Test for PostgreSQL9
References: <AANLkTi=UEQmkjtkUcgoEbj=zu6DYskyNH5m6qqL79QYp@mail.gmail.com>
	<AANLkTi=RGgtjoQkzwHsPrq1LHV+fb2+rmwyBZX0kT+UB@mail.gmail.com>
	<1299090595.25659.135.camel@jd-desktop>
	<AANLkTi=_T_pXg2+YNNPLyJeAccfebdbtRmUGkin1q2aA@mail.gmail.com>
In-Reply-To: <AANLkTi=_T_pXg2+YNNPLyJeAccfebdbtRmUGkin1q2aA@mail.gmail.com>
Content-Type: multipart/alternative;
	boundary="------------040502060908010601030209"
X-Provags-ID: V02:K0:POlGAmxHcsrWzvA2eZ6aBW4cjPM0LZw/aSjAAY364Cm
	RVoh8bG1QYqeUs2COolqG1IVd/ojQcKRH/MvnLL0JZs/9Eqj1L
	sLa+eqeu56mrOrO6eBA8W/L3g9RRzBCmc5C9Xp4L38YsgabWn3
	joKkITqMZweAaMbDIDA3nKN68ORXyJ183AFkr2bYr2BsDYO8IU
	JsAatqgHkYkJv8UndVlcklDwY7EdKqZqmpoCI3DfVw=
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.899 tagged_above=-10 required=5
	tests=BAYES_00=-1.9, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001
X-Spam-Level: 
X-Archive-Number: 201103/29
X-Sequence-Number: 42708

This is a multi-part message in MIME format.
--------------040502060908010601030209
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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


--------------040502060908010601030209
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Selva manickaraja wrote:
<blockquote
 cite="mid:AANLkTi=_T_pXg2+YNNPLyJeAccfebdbtRmUGkin1q2aA@mail.gmail.com"
 type="cite"><span style="color: rgb(0, 0, 0);"></span><span class="gI"><span
 class="gD" style="color: rgb(200, 137, 0);"><span
 style="color: rgb(0, 0, 0);">The reason I had to compile is because
there are no binaries for regression tests and the documentation
requires us to make-install.</span><br>
  </span></span></blockquote>
<br>
The reason for that is there is little reason for users of the database
to ever run those.&nbsp; Most (possibly all) of the the packaged builds will
run the regression tests as part of the build process.&nbsp; So the odds of
you finding an error with them is pretty low.&nbsp; <br>
<br>
I'm getting the impression you think that the regression tests are
somehow useful for performance testing.&nbsp; They aren't; they are strictly
code quality tests.&nbsp; The only performance testing tool that comes with
the database is pgbench, which is a tricky tool to get useful test
results from.<br>
<br>
<pre class="moz-signature" cols="72">-- 
Greg Smith   2ndQuadrant US    <a class="moz-txt-link-abbreviated" href="mailto:greg@2ndQuadrant.com">greg@2ndQuadrant.com</a>   Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support  <a class="moz-txt-link-abbreviated" href="http://www.2ndQuadrant.us">www.2ndQuadrant.us</a>
"PostgreSQL 9.0 High Performance": <a class="moz-txt-link-freetext" href="http://www.2ndQuadrant.com/books">http://www.2ndQuadrant.com/books</a>
</pre>
</body>
</html>

--------------040502060908010601030209--