Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bmeoq-0007le-4f for pgsql-hackers@arkaria.postgresql.org; Wed, 21 Sep 2016 10:32:00 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1bmeop-0006Ua-MU for pgsql-hackers@arkaria.postgresql.org; Wed, 21 Sep 2016 10:31:59 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1bmenR-0004Eo-4a for pgsql-hackers@postgresql.org; Wed, 21 Sep 2016 10:30:33 +0000 Received: from mail-lf0-x22d.google.com ([2a00:1450:4010:c07::22d]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1bmenN-0007hE-Uf for pgsql-hackers@postgresql.org; Wed, 21 Sep 2016 10:30:32 +0000 Received: by mail-lf0-x22d.google.com with SMTP id l131so36926541lfl.2 for ; Wed, 21 Sep 2016 03:30:29 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=sender:subject:to:references:cc:from:message-id:date:user-agent :mime-version:in-reply-to:content-transfer-encoding; bh=wk4dkfuhxIuD+UdNMeJJaJVeOPGc3e/WBoyvkHrM6Yc=; b=Vy1qy3KOUaWUO3PzdkCVso2ZOKBdf+0qSRLZ30w76U7bRx8y+vZszw+zyqEljorm0x Cb0xvO2mWTvNsuFal3qr5P44OjIX+uwliQyMnRyCeeOmhrYSn+N6fFH3B23LPHHCRurY EEXAZkZyBEq0nViR1z054Oyd12FXmxlr5JpSLsu9+o1g3Z/RwC+ZpDuz02imqzfECAwQ jsXYmADAuFYxbFRZmOFMzMlreYImz0W7ykpS7iCH/5TwXXpjdnIZn0WTxv8tRK5gYXkb GqTpo0EbRRSsoQlHEmAkdesCOZm8dzFA+qnEQjj0zJgCKX0Q74fJneHcrpFop9UpVCUW LNPQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:sender:subject:to:references:cc:from:message-id :date:user-agent:mime-version:in-reply-to:content-transfer-encoding; bh=wk4dkfuhxIuD+UdNMeJJaJVeOPGc3e/WBoyvkHrM6Yc=; b=PpSzNMjZm0c3zp8XgUbPoDQsXffq4qn1GXzXssQuf8pjhKIbxxkP6aPtL5MyMoYYwB i3ZlQPc3/ur4Y9eF3YiZi9fsLvkxGbiHWR5nOASsfunuXQ8jN+yBTCX7YsQRrFKlI4Cl HR53jiVHrIAG6JquOeU9+5Zrp0l5hTUxvjReP2tgRXgR2m0iadonwiQG0IqU2iPSZR43 Rjc+5PTc/PsFZrWupgsipXPI3rCCEfG7k0P/3SV+dVyVNyx6xxEvBl4k10EkqXccR7TN R4bD79N0Xe+6/FosYxuT6frAR0O79TJp1jdjxISM/1khPQoBfei2eWmkCjLR+GU6Hr4X twug== X-Gm-Message-State: AE9vXwPV24q5HiD7inwsX0TjrgZ299i/I8TmZTxDiUBkJL4x66sXDIg3FzRzgaJ0ZLwWJA== X-Received: by 10.46.0.221 with SMTP id e90mr14890221lji.34.1474453829247; Wed, 21 Sep 2016 03:30:29 -0700 (PDT) Received: from [192.168.1.111] (dsl-hkibrasgw1-58c38f-82.dhcp.inet.fi. [88.195.143.82]) by smtp.gmail.com with ESMTPSA id 202sm6700577ljf.33.2016.09.21.03.30.28 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Wed, 21 Sep 2016 03:30:28 -0700 (PDT) Subject: Re: pgbench - compute & show latency consistently To: Fabien COELHO , Peter Eisentraut References: Cc: PostgreSQL Developers From: Heikki Linnakangas Message-ID: <68f175fc-9a7d-825b-e573-63d998ced452@iki.fi> Date: Wed, 21 Sep 2016 13:30:27 +0300 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:45.0) Gecko/20100101 Icedove/45.2.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -2.6 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org On 07/13/2016 11:39 AM, Fabien COELHO wrote: >>> number of transactions per client: 1000 >>> -latency average = 15.844 ms >>> +latency average: 15.844 ms >>> tps = 618.764555 (including connections establishing) >> >> I think what you have here is that colons separate input parameters and >> equal signs separate result output. So I think it's OK the way it is. > > Hmmm... Then other measures displayed are not all consistent with this > theory. > > Also there is still the bug under -t which displays a 0 latency. > > The attached patch still fixes that and make it consistent the other way > around, i.e. by using "=" for latency. I switched to use ":" for weight > which is an input parameter. I let ":" when there is a long sentence to > describe the figure displayed, more on aesthetical grounds. Committed, thanks! - Heikki -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers