X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 5302A9DC9A9 for ; Fri, 10 Feb 2006 11:40:58 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 02302-09 for ; Fri, 10 Feb 2006 11:41:02 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.199]) by postgresql.org (Postfix) with ESMTP id AEFFE9DC997 for ; Fri, 10 Feb 2006 11:40:55 -0400 (AST) Received: by zproxy.gmail.com with SMTP id i28so460821nzi for ; Fri, 10 Feb 2006 07:41:00 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=j9r4T39VsNUR7hKwcAB/0o0vXmIhwcDB2JBl6f3LMHnHcEUFztXgVYfpKAsq96sZApGCyhopuxImTt//abCrigUBjtNt6J1fTJG70NPi8qRlgwcBMpkYDwNVC0/iqojRK7+dDSCIdt/GHlw4dnaKWV2V/pfEnfzxtZoUhh/0ycM= Received: by 10.37.20.33 with SMTP id x33mr3660228nzi; Fri, 10 Feb 2006 07:41:00 -0800 (PST) Received: by 10.36.71.10 with HTTP; Fri, 10 Feb 2006 07:41:00 -0800 (PST) Message-ID: <674d1f8a0602100741y454ccd77ld445888d1cfa420e@mail.gmail.com> Date: Fri, 10 Feb 2006 21:11:00 +0530 From: Gourish Singbal To: "Jim C. Nasby" Subject: Re: pgbench output Cc: Pradeep Parmar , pgsql-performance@postgresql.org In-Reply-To: <20060207050626.GA1240@pervasive.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_25084_13384017.1139586060015" References: <580055310602012309o40b9b0d4g@mail.gmail.com> <20060207050626.GA1240@pervasive.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.134 required=5 tests=[AWL=0.133, HTML_MESSAGE=0.001] X-Spam-Score: 0.134 X-Spam-Level: X-Archive-Number: 200602/103 X-Sequence-Number: 17089 ------=_Part_25084_13384017.1139586060015 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Hi All, Here are some of the results i got after performing pgbench marking between postgresql 7.4.5 and postgresql 8.1.2. having parameters with same values i= n the postgresql.conf file. postgres@machine:/newdisk/postgres/data> /usr/local/pgsql7.4.5/bin/pgbench -c 10 -t 10000 regression starting vacuum...end. transaction type: TPC-B (sort of) scaling factor: 10 number of clients: 10 number of transactions per client: 10000 number of transactions actually processed: 100000/100000 tps =3D 80.642615 (including connections establishing) tps =3D 80.650638 (excluding connections establishing) postgres@machine:/newdisk/postgres/data> /usr/local/pgsql/bin/pgbench -c 10 -t 10000 regression starting vacuum...end. transaction type: TPC-B (sort of) scaling factor: 10 number of clients: 10 number of transactions per client: 10000 number of transactions actually processed: 100000/100000 tps =3D 124.134926 (including connections establishing) tps =3D 124.148749 (excluding connections establishing) Conclusion : So please correct me if i am wrong ... this result set shows that the postgresql version 8.1.2 has perform better than 7.4.5 in the bench marking process since 8.1.2 was able to complete more transcations pe= r second successfully . On 2/7/06, Jim C. Nasby wrote: > Well, it tells you how many transactions per second it was able to do. > Do you have specific questions? > > On Thu, Feb 02, 2006 at 12:39:59PM +0530, Pradeep Parmar wrote: > > Hi, > > > > I'm fairly new to PostgreSQL. I was trying pgbench , but could not > > understand the output . Can anyone help me out to understand the output > of > > pgbench > > > > > > ----Pradeep > > -- > Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com > Pervasive Software http://pervasive.com work: 512-231-6117 > vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster > -- Best, Gourish Singbal ------=_Part_25084_13384017.1139586060015 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline
 
Hi All,
 
Here are some of the results i got after performing pgbench marking be= tween postgresql 7.4.5 and postgresql 8.1.2. having parameters with same va= lues in the postgresql.conf file.
 
postgres@ma= chine:/newdisk/postgres/data> /usr/local/pgsql7.4.5/bin/pgbench -c 1= 0 -t 10000 regression
starting vacuum...end.
transaction type: TPC-B = (sort of)
scaling factor: 10
number of clients: 10
number of transactions p= er client: 10000
number of transactions actually processed: 100000/10000= 0
tps =3D 80.642615 (including connections establishing)
tps =3D 80.6= 50638 (excluding connections establishing)

postgres@mach= ine:/newdisk/postgres/data> /usr/local/pgsql/bin/pgbench -c 10 -t 10= 000 regression
starting vacuum...end.
transaction type: TPC-B (sort o= f)
scaling factor: 10
number of clients: 10
number of transactions p= er client: 10000
number of transactions actually processed: 100000/10000= 0
tps =3D 124.134926 (including connections establishing)
tps =3D 124= .148749 (excluding connections establishing)

Conclusion : So please correct me if i am wrong ... this result set show= s that the postgresql version  8.1.2 has perform better than 7.4.5&nbs= p;in the bench marking process since 8.1.2 was able to complete more transc= ations per second successfully .=20


On 2/7/06, Jim C. Nasby <jnasby@pervas= ive.com> wrote:

Well, it tells you how many tran= sactions per second it was able to do.
Do you have specific questions?
On Thu, Feb 02, 2006 at 12:39:59PM +0530, Pradeep Parmar wrote:
>= Hi,
>
> I'm fairly new to PostgreSQL. I was trying pgbench , b= ut could not
> understand the output . Can anyone help me out to unde= rstand the output of
> pgbench
>
>
> ----Pradeep

--
Jim C. Na= sby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Soft= ware       http://pervasive.com    work: 512-231-6117
vcard= : http://jim.nasby.net/perva= sive.vcf       cell: 512-569-9461

= ---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster



--
Best,
Gourish Singbal=20 ------=_Part_25084_13384017.1139586060015--