Received: from maia.hub.org (maia-2.hub.org [200.46.204.251])
	by mail.postgresql.org (Postfix) with ESMTP id 10EA51EA5096
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Sat,  5 Nov 2011 12:55:15 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia,
	port 10024) with ESMTP id 47375-01-9
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Sat,  5 Nov 2011 15:55:08 +0000 (UTC)
X-Greylist: delayed 00:09:38.258547 by SQLgrey-1.8.0-rc2
Received: from bounce-out.neti.ee (bounce-out.neti.ee [194.126.101.104])
	by mail.postgresql.org (Postfix) with ESMTP id 9469D1590675
	for <pgsql-admin@postgresql.org>; Sat,  5 Nov 2011 12:53:40 -0300 (ADT)
Received: from mail.hot.ee (mx1.hot.ee [194.126.101.119])
	by Bounce1.estpak.ee (Postfix) with ESMTP id E488E19A9
	for <pgsql-admin@postgresql.org>; Sat,  5 Nov 2011 17:44:25 +0200 (EET)
Received: from localhost (localhost [127.0.0.1])
	by vm-hot-relay10.estpak.ee (Postfix) with ESMTP id BB95290
	for <pgsql-admin@postgresql.org>; Sat,  5 Nov 2011 17:43:59 +0200 (EET)
X-Virus-Scanned: Debian amavisd-new at vm-hot-relay10.estpak.ee
Received: from mail.hot.ee ([127.0.0.1])
	by localhost (vm-hot-relay10.estpak.ee [127.0.0.1]) (amavisd-new,
	port 10024)
	with ESMTP id 0nwnh02+j-vV for <pgsql-admin@postgresql.org>;
	Sat,  5 Nov 2011 17:43:57 +0200 (EET)
Received: from mh5 (unknown [10.3.0.123])
	by vm-hot-relay10.estpak.ee (Postfix) with ESMTP id 03C663E0
	for <pgsql-admin@postgresql.org>; Sat,  5 Nov 2011 17:43:57 +0200 (EET)
X-Mailer: Elion hot.ee Webmail (http://www.hot.ee)
From: Jelena <gjelena@hot.ee>
Date: Sat, 05 Nov 2011 17:43:51 +0200
To: pgsql-admin@postgresql.org
Cc: 
Subject: PostgreSQL statement latency
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="--------=BoundaryPyDog1320507831.83------"
Message-Id: <20111105155340.9469D1590675@mail.postgresql.org>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.898 tagged_above=-10 required=5
	tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 201111/11
X-Sequence-Number: 38605


----------=BoundaryPyDog1320507831.83------
Content-Type: text/plain;
    charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Hi,=20

What is the right way to measure PostgreSQL statements
latencies in pgbench? I found several solutions:

1. in PostgreSQL
9.1 (for example, with an option -r) -> pgbench=C2=A0=C2=A0-S -c 8=C2=A0 -t=
 2000 -r
pgbench

2.
http://www.westnet.com/~gsmith/content/postgresql/pgbench.htm (is this
solution only for version 8.2.3)?

I would like to build the graph
- Latency (ms) versus Time during test. I am running PostgreSQL on
Windows 7 - How could I do it?




----------------------------
Vaata, mida p=C3=B5nevat telest tuleb!
minuTV.ee
www.minutv.ee

----------=BoundaryPyDog1320507831.83------
Content-Type: text/html;
    charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Hi, <br><br>What is the right way to measure PostgreSQL statements
latencies in pgbench? I found several solutions:<br><br>1. in PostgreSQL
9.1 (for example, with an option -r) -&gt; pgbench&nbsp;&nbsp;<span
style=3D"font-family: monospace;"></span>-S -c 8&nbsp; -t 2000 -r
pgbench<br><br>2.
http://www.westnet.com/~gsmith/content/postgresql/pgbench.htm (is this
solution only for version 8.2.3)?<br><br>I would like to build the graph
- Latency (ms) versus Time during test. I am running PostgreSQL on
Windows 7 - How could I do it?<br><br><br>
<br>
<br>
----------------------------<br>
Vaata, mida p=C3=B5nevat telest tuleb!<br>
<a href=3D"http://ads.hot.ee/reklaam/click?rel=3D4cbc362412ea4"  title=3D"w=
ww.minutv.ee" >minuTV.ee</a><br>

----------=BoundaryPyDog1320507831.83--------