Received: from localhost (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 4E49E64FC52
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Sun, 21 Dec 2008 05:29:52 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 63301-09
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Sun, 21 Dec 2008 05:29:49 -0400 (AST)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from rv-out-0506.google.com (rv-out-0506.google.com
 [209.85.198.234])
	by mail.postgresql.org (Postfix) with ESMTP id 6633D64FC27
	for <pgsql-performance@postgresql.org>;
	Sun, 21 Dec 2008 05:29:49 -0400 (AST)
Received: by rv-out-0506.google.com with SMTP id b25so2974440rvf.43
	for <pgsql-performance@postgresql.org>;
	Sun, 21 Dec 2008 01:29:48 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:received:received:cc:message-id:from:to
	:in-reply-to:content-type:content-transfer-encoding:mime-version
	:subject:date:references:x-mailer;
	bh=5psq7JohDHxVybZK8mDvDqlLeXPU+SWACgpEb/tMmpc=;
	b=Ml1bH51wS1LTB34+vQuV+hGaUJakfpH/CJa9EZ8tAL3x9ODlVb0Pob/uPVtxOpYskg
	9RFmBletoRuczE/kIGBfEGX3zanugzKlFekROQDS9muTVrwj7i5pKQD5koqCyqLB7FI3
	tpibs1oy7y8wz0+9+fO7NuQpkcivHR+iepPls=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=cc:message-id:from:to:in-reply-to:content-type
	:content-transfer-encoding:mime-version:subject:date:references
	:x-mailer;
	b=Y+Mkr9gWLaAnFZagd7Takgi1hoHJSeuSa9JvT8iHKJ/PEU4HyziR1jo9pR0lwjXLEJ
	lzqf7M2O1ebw7m/Kb579oiLO4sKErSo9bE03/jM3RlOdrRgUC1QdDm/9YMUTCm3nff8f
	kWadg3/eEy2sUfQZBITEhgak2pQ4pwBcabcj4=
Received: by 10.140.132.4 with SMTP id f4mr2538611rvd.291.1229851788271;
	Sun, 21 Dec 2008 01:29:48 -0800 (PST)
Received: from ?192.168.15.103? (97-115-23-31.ptld.qwest.net [97.115.23.31])
	by mx.google.com with ESMTPS id f21sm14039569rvb.7.2008.12.21.01.29.47
	(version=TLSv1/SSLv3 cipher=RC4-MD5);
	Sun, 21 Dec 2008 01:29:47 -0800 (PST)
Cc: "pgsql-performance\@postgresql.org" <pgsql-performance@postgresql.org>,
	"Selena Deckelmann" <selenamarie@gmail.com>,
	"Gabrielle Roth" <gorthx@gmail.com>
Message-Id: <552F108E-9732-4ED6-B45D-6C651C63565E@gmail.com>
From: Mark Wong <markwkm@gmail.com>
To: Gregory Stark <stark@enterprisedb.com>
In-Reply-To: <87hc4yuxbl.fsf@oxford.xeocode.com>
Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes
Content-Transfer-Encoding: 7bit
Mime-Version: 1.0 (Apple Message framework v930.3)
Subject: Re: dbt-2 tuning results with postgresql-8.3.5
Date: Sun, 21 Dec 2008 01:29:46 -0800
References: <70c01d1d0812201654i5f55150ep619a6c7ff094470@mail.gmail.com>
	<87hc4yuxbl.fsf@oxford.xeocode.com>
X-Mailer: Apple Mail (2.930.3)
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none
X-Spam-Level: 
X-Archive-Number: 200812/176
X-Sequence-Number: 32212


On Dec 20, 2008, at 5:33 PM, Gregory Stark wrote:

> "Mark Wong" <markwkm@gmail.com> writes:
>
>> To recap, dbt2 is a fair-use derivative of the TPC-C benchmark.  We
>> are using a 1000 warehouse database, which amounts to about 100GB of
>> raw text data.
>
> Really? Do you get conforming results with 1,000 warehouses? What's  
> the 95th
> percentile response time?

No, the results are not conforming.  You and others have pointed that  
out already.  The 95th percentile response time are calculated on each  
page of the previous links.

I find your questions a little odd for the input I'm asking for.  Are  
you under the impression we are trying to publish benchmarking  
results?  Perhaps this is a simple misunderstanding?

Regards,
Mark