Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtp (Exim 4.84_2)
	(envelope-from
 <pgsql-hackers-owner+M306840=pgsql-hackers-arkari@postgresql.org>)
	id 1bmhVT-0007aZ-JT
	for pgsql-hackers@arkaria.postgresql.org; Wed, 21 Sep 2016 13:24:11 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
	by malur.postgresql.org with smtp (Exim 4.84_2)
	(envelope-from
 <pgsql-hackers-owner+M306840=pgsql-hackers-arkari@postgresql.org>)
	id 1bmhVT-0000gF-6Q
	for pgsql-hackers@arkaria.postgresql.org; Wed, 21 Sep 2016 13:24:11 +0000
Received: from makus.postgresql.org ([2001:4800:1501:1::229])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
	(Exim 4.84_2)
	(envelope-from <coelho@cri.ensmp.fr>)
	id 1bmhVQ-0000Y0-Iy
	for pgsql-hackers@postgresql.org; Wed, 21 Sep 2016 13:24:08 +0000
Received: from jiboia.ensmp.fr ([194.214.158.137]
 helo=cc-tupan-roaming-a.ensmp.fr)
	by makus.postgresql.org with esmtp (Exim 4.84_2)
	(envelope-from <coelho@cri.ensmp.fr>)
	id 1bmhVN-00018S-PZ
	for pgsql-hackers@postgresql.org; Wed, 21 Sep 2016 13:24:07 +0000
Received: from cri.ensmp.fr (50.154.219.88.rev.sfr.net [88.219.154.50])
	(authenticated bits=0)
	by cc-tupan-roaming-a.ensmp.fr (8.15.2/8.15.1/JMMC-22/Oct/2013) with ESMTPSA
 id u8LDNlAj007026
	(version=TLSv1.2 cipher=ECDHE-RSA-AES256-GCM-SHA384 bits=256 verify=NO);
	Wed, 21 Sep 2016 15:23:49 +0200
Date: Wed, 21 Sep 2016 15:23:46 +0200 (CEST)
From: Fabien COELHO <coelho@cri.ensmp.fr>
X-X-Sender: fabien@lancre
To: Kuntal Ghosh <kuntalghosh.2007@gmail.com>
cc: Heikki Linnakangas <hlinnaka@iki.fi>,
        PostgreSQL-development <pgsql-hackers@postgresql.org>
Subject: Re: pgbench - compute & show latency consistently
In-Reply-To: 
 <CAGz5QC+ZH5KngUZBSFztKA5t6_EPvZfueo0rs_H3VFyfdZabpg@mail.gmail.com>
Message-ID: <alpine.DEB.2.20.1609211510240.1634@lancre>
References: 
 <CAGz5QCJjBxLgqt9=uC3gRJUnTGh6BZsMivs7iyPLw0LD_TURsw@mail.gmail.com>
 <46face3d-b9c8-2676-f63d-f96f8c3a658f@iki.fi>
 <CAGz5QC+ZH5KngUZBSFztKA5t6_EPvZfueo0rs_H3VFyfdZabpg@mail.gmail.com>
User-Agent: Alpine 2.20 (DEB 67 2015-01-07)
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII; format=flowed
X-Miltered: at cc-tupan-roaming-a.ensmp.fr with ID 57E289E3.000 by Joe's
 j-chkmail (http : // j-chkmail dot ensmp dot fr)!
X-j-chkmail-Auth: USER-ID fabien.coelho
X-j-chkmail-Enveloppe: 57E289E3.000 from
 50.154.219.88.rev.sfr.net/50.154.219.88.rev.sfr.net/88.219.154.50/cri.ensmp.fr/<coelho@cri.ensmp.fr>
X-Pg-Spam-Score: -5.0 (-----)
List-Archive: <http://archives.postgresql.org/pgsql-hackers>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-hackers.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@postgresql.org>
List-Post: <mailto:pgsql-hackers@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-hackers>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-hackers>
X-Mailing-List: pgsql-hackers
Precedence: bulk
Sender: pgsql-hackers-owner@postgresql.org


Hello Kuntal,

> <screen>
> transaction type: &lt;builtin: TPC-B (sort of)&gt;
> scaling factor: 10
> query mode: simple
> number of clients: 10
> number of threads: 1
> number of transactions per client: 1000
> number of transactions actually processed: 10000/10000
> tps = 85.184871 (including connections establishing)
> tps = 85.296346 (excluding connections establishing)
> </screen>
>
> Shouldn't we include latency average here as well and explain what it is?

Indeed, now it seems to be always printed but the documentation did not 
follow, there should be a:

   latency average = 117.392 ms

In front of the tps line. Well, the performance displayed could also be 
improved... On my dual core SSD laptop I just got:

  sh> ./pgbench -c 10 -t 1000
  starting vacuum...end.
  transaction type: <builtin: TPC-B (sort of)>
  scaling factor: 100
  query mode: simple
  number of clients: 10
  number of threads: 1
  number of transactions per client: 1000
  number of transactions actually processed: 10000/10000
  latency average = 9.527 ms
  tps = 1049.665115 (including connections establishing)
  tps = 1049.890194 (excluding connections establishing)

Which is about 10 times better.

-- 
Fabien.


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers