Received: from localhost (maia-4.hub.org [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 195149FB8A7
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Wed, 14 Feb 2007 11:35:57 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024)
	with ESMTP id 97337-03 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Wed, 14 Feb 2007 11:35:56 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.4
Received: from exprod6og54.obsmtp.com (exprod6og54.obsmtp.com [64.18.1.189])
	by postgresql.org (Postfix) with SMTP id 2BE0E9FB795
	for <pgsql-performance@postgresql.org>;
	Wed, 14 Feb 2007 11:35:55 -0400 (AST)
Received: from source ([63.240.6.46]) (using TLSv1) by exprod6ob54.postini.com
	([64.18.5.12]) with SMTP; Wed, 14 Feb 2007 07:35:53 PST
Received: from 172.16.1.25 by mail.mi8.com with ESMTP (- Welcome to Mi8
	Corporation www.Mi8.com (D2)); Wed, 14 Feb 2007 10:35:45 -0500
X-Server-Uuid: 7829E76E-BB9E-4995-8473-3C0929DF7DD1
Received: from MI8NYCMAIL08.Mi8.com ([172.16.1.164]) by
	D01HOST03.Mi8.com with Microsoft SMTPSVC(6.0.3790.1830); Wed, 14 Feb
	2007 10:35:44 -0500
Received: from 24.23.197.133 ([24.23.197.133]) by MI8NYCMAIL08.Mi8.com (
	[172.16.1.190]) via Exchange Front-End Server mi8owa.mi8.com (
	[172.16.1.106]) with Microsoft Exchange Server HTTP-DAV ; Wed, 14 Feb
	2007 15:35:44 +0000
User-Agent: Microsoft-Entourage/11.3.3.061214
Date: Wed, 14 Feb 2007 07:35:43 -0800
Subject: Re: Benchmarking PGSQL?
From: "Luke Lonergan" <llonergan@greenplum.com>
To: "Krishna Kumar" <kumar.ramanathan@gmail.com>,
	pgsql-performance@postgresql.org
Message-ID: <C1F86C4F.27217%llonergan@greenplum.com>
Thread-Topic: [PERFORM] Benchmarking PGSQL?
Thread-Index: AcdQTcmyCGHisLxBEdu7eQAWy4o9DA==
In-Reply-To: <eed7b2c20702140200v3d6ea5f6jec466f95dd6f8012@mail.gmail.com>
MIME-Version: 1.0
X-OriginalArrivalTime: 14 Feb 2007 15:35:44.0865 (UTC)
	FILETIME=[CACF8510:01C7504D]
X-WSS-ID: 69CDF3DB32K10079769-01-01
Content-Type: multipart/alternative;
 boundary=B_3254283344_16765
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200702/151
X-Sequence-Number: 23205

> This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

--B_3254283344_16765
Content-Type: text/plain;
 charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

Here=B9s one:

Insert performance is limited to about 10-12 MB/s no matter how fast the
underlying I/O hardware.  Bypassing the WAL (write ahead log) only boosts
this to perhaps 20 MB/s.  We=B9ve found that the biggest time consumer in the
profile is the collection of routines that =B3convert to datum=B2.

You can perform the test using any dataset, you might consider using the
TPC-H benchmark kit with a data generator available at www.tpc.org.  Just
generate some data, load the schema, then perform some COPY statements,
INSERT INTO SELECT FROM and CREATE TABLE AS SELECT.

- Luke


On 2/14/07 2:00 AM, "Krishna Kumar" <kumar.ramanathan@gmail.com> wrote:

> Hello All,=20
> I'm a performance engineer, quite interested in getting deep into the PGS=
QL
> performance enhancement effort. In that regard, I have the following ques=
tions
> :=20
> 1. Is there a benchmarking setup, that I can access online?
> 2. What benchmarks are we running , for performance numbers?
> 3. What are the current issues, related to performance?
> 4. Where can I start, with the PGSQL performance effort?
>=20
> Thanks a lot,=20
> Krishna=20
>=20



--B_3254283344_16765
Content-Type: text/html;
 charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

<HTML>
<HEAD>
<TITLE>Re: [PERFORM] Benchmarking PGSQL?</TITLE>
</HEAD>
<BODY>
<FONT FACE=3D"Verdana, Helvetica, Arial"><SPAN STYLE=3D'font-size:14.0px'>Here&=
#8217;s one:<BR>
<BR>
Insert performance is limited to about 10-12 MB/s no matter how fast the un=
derlying I/O hardware. &nbsp;Bypassing the WAL (write ahead log) only boosts=
 this to perhaps 20 MB/s. &nbsp;We&#8217;ve found that the biggest time cons=
umer in the profile is the collection of routines that &#8220;convert to dat=
um&#8221;.<BR>
<BR>
You can perform the test using any dataset, you might consider using the TP=
C-H benchmark kit with a data generator available at www.tpc.org. &nbsp;Just=
 generate some data, load the schema, then perform some COPY statements, INS=
ERT INTO SELECT FROM and CREATE TABLE AS SELECT.<BR>
<BR>
- Luke<BR>
<BR>
<BR>
On 2/14/07 2:00 AM, &quot;Krishna Kumar&quot; &lt;kumar.ramanathan@gmail.co=
m&gt; wrote:<BR>
<BR>
</SPAN></FONT><BLOCKQUOTE><FONT FACE=3D"Verdana, Helvetica, Arial"><SPAN STYL=
E=3D'font-size:14.0px'>Hello All, <BR>
I'm a performance engineer, quite interested in getting deep into the PGSQL=
 performance enhancement effort. In that regard, I have the following questi=
ons : <BR>
1. Is there a benchmarking setup, that I can access online? <BR>
2. What benchmarks are we running , for performance numbers?<BR>
3. What are the current issues, related to performance? <BR>
4. Where can I start, with the PGSQL performance effort?<BR>
<BR>
Thanks a lot, <BR>
Krishna <BR>
<BR>
</SPAN></FONT></BLOCKQUOTE><FONT FACE=3D"Verdana, Helvetica, Arial"><SPAN STY=
LE=3D'font-size:14.0px'><BR>
</SPAN></FONT>
</BODY>
</HTML>


--B_3254283344_16765--