X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 3964C9F9ED6; Thu, 22 Jun 2006 10:22:58 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 75521-06; Thu, 22 Jun 2006 10:22:47 -0300 (ADT) X-Greylist: delayed 00:18:51.797169 by SQLgrey- X-Greylist: from auto-whitelisted by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id A21089FA621; Thu, 22 Jun 2006 10:22:44 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from out3.smtp.messagingengine.com (out3.smtp.messagingengine.com [66.111.4.27]) by svr4.postgresql.org (Postfix) with ESMTP id D48F95AF04F; Thu, 22 Jun 2006 13:03:50 +0000 (GMT) Received: from frontend3.internal (frontend3.internal [10.202.2.152]) by frontend1.messagingengine.com (Postfix) with ESMTP id 8FCCBD85F49; Thu, 22 Jun 2006 09:03:48 -0400 (EDT) Received: from heartbeat1.messagingengine.com ([10.202.2.160]) by frontend3.internal (MEProxy); Thu, 22 Jun 2006 09:03:49 -0400 X-Sasl-enc: vS8IU6LgCSrQi69DZvJzV9+8ptwBt29BDLmRH+tcVoKL 1150981428 Received: from [149.191.9.25] (unknown [129.230.248.1]) by mail.messagingengine.com (Postfix) with ESMTP id 7EAE15043; Thu, 22 Jun 2006 09:03:48 -0400 (EDT) Message-ID: <449A9533.1030103@diroussel.xsmail.com> Date: Thu, 22 Jun 2006 14:03:47 +0100 From: David Roussel User-Agent: Thunderbird 1.5.0.4 (Windows/20060516) MIME-Version: 1.0 Cc: pgsql-hackers@postgresql.org, pgsql-performance@postgresql.org Subject: Re: [HACKERS] Sun Donated a Sun Fire T2000 to the PostgreSQL References: <4492CBE2.3090509@sun.com> <449331EC.10207@tweakers.net> <200606161624.17081.josh@agliodbs.com> <44951A42.6060007@tweakers.net> In-Reply-To: <44951A42.6060007@tweakers.net> Content-Type: multipart/alternative; boundary="------------090200070504010008060904" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/444 X-Sequence-Number: 19801 This is a multi-part message in MIME format. --------------090200070504010008060904 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Arjen van der Meijden wrote: > > Here is a graph of our performance measured on PostgreSQL: > http://achelois.tweakers.net/~acm/pgsql-t2000/T2000-schaling-postgresql.png > > ... > > The "perfect" line is based on the "Max" value for 1 core and then > just multiplied by the amount of cores to have a linear reference. The > "Bij 50" and the "perfect" line don't differ too much in color, but > the top-one is the "perfect" line. Sureky the 'perfect' line ought to be linear? If the performance was perfectly linear, then the 'pages generated' ought to be G times the number (virtual) processors, where G is the gradient of the graph. In such a case the graph will go through the origin (o,o), but you graph does not show this. I'm a bit confused, what is the 'perfect' supposed to be? Thanks David --------------090200070504010008060904 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit
Arjen van der Meijden wrote:

Here is a graph of our performance measured on PostgreSQL:
http://achelois.tweakers.net/~acm/pgsql-t2000/T2000-schaling-postgresql.png

...

The "perfect" line is based on the "Max" value for 1 core and then just multiplied by the amount of cores to have a linear reference. The "Bij 50" and the "perfect" line don't differ too much in color, but the top-one is the "perfect" line.

Sureky the 'perfect' line ought to be linear?  If the performance was perfectly linear, then the 'pages generated' ought to be G times the number (virtual) processors, where G is the gradient of the graph.  In such a case the graph will go through the origin (o,o), but you graph does not show this. 

I'm a bit confused, what is the 'perfect' supposed to be?

Thanks

David
--------------090200070504010008060904--