Received: from localhost (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 5596364FC7D
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Sat, 20 Dec 2008 21:33:10 -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 99650-08
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Sat, 20 Dec 2008 21:33:07 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from yw-out-2324.google.com (yw-out-2324.google.com [74.125.46.31])
	by mail.postgresql.org (Postfix) with ESMTP id D272564FC56
	for <pgsql-performance@postgresql.org>;
	Sat, 20 Dec 2008 21:33:07 -0400 (AST)
Received: by yw-out-2324.google.com with SMTP id 3so541391ywj.73
	for <pgsql-performance@postgresql.org>;
	Sat, 20 Dec 2008 17:33:06 -0800 (PST)
Received: by 10.64.96.3 with SMTP id t3mr3764171qbb.96.1229823186305;
	Sat, 20 Dec 2008 17:33:06 -0800 (PST)
Received: from oxford.xeocode.com.enterprisedb.com
	(69-196-135-189.dsl.teksavvy.com [69.196.135.189])
	by mx.google.com with ESMTPS id k29sm9866225qba.27.2008.12.20.17.33.04
	(version=TLSv1/SSLv3 cipher=RC4-MD5);
	Sat, 20 Dec 2008 17:33:05 -0800 (PST)
To: "Mark Wong" <markwkm@gmail.com>
Cc: "pgsql-performance\@postgresql.org" <pgsql-performance@postgresql.org>,
	"Selena Deckelmann" <selenamarie@gmail.com>,
	"Gabrielle Roth" <gorthx@gmail.com>
Subject: Re: dbt-2 tuning results with postgresql-8.3.5
In-Reply-To: <70c01d1d0812201654i5f55150ep619a6c7ff094470@mail.gmail.com>
	(Mark Wong's message of "Sat\, 20 Dec 2008 16\:54\:39 -0800")
User-Agent: Gnus/5.11 (Gnus v5.11) Emacs/22.1 (gnu/linux)
X-Draft-From: ("nnimap+imap.gmail.com:PG" 101726)
References: <70c01d1d0812201654i5f55150ep619a6c7ff094470@mail.gmail.com>
From: Gregory Stark <stark@enterprisedb.com>
Organization: EnterpriseDB
Date: Sun, 21 Dec 2008 01:33:02 +0000
Message-ID: <87hc4yuxbl.fsf@oxford.xeocode.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
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/173
X-Sequence-Number: 32209

"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?

-- 
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com
  Ask me about EnterpriseDB's On-Demand Production Tuning