<feed xmlns='http://www.w3.org/2005/Atom'>
<title>delta/postgresql.git/doc/src/sgml/pgbench.sgml, branch master</title>
<subtitle>git.postgresql.org: git/postgresql.git
</subtitle>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/postgresql.git/'/>
<entry>
<title>Move pgbench from contrib/ to src/bin/</title>
<updated>2015-04-13T17:07:16+00:00</updated>
<author>
<name>Peter Eisentraut</name>
<email>peter_e@gmx.net</email>
</author>
<published>2015-03-11T02:33:24+00:00</published>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/postgresql.git/commit/?id=81134af3ec09d67043833f8d614fd688f17cb213'/>
<id>81134af3ec09d67043833f8d614fd688f17cb213</id>
<content type='text'>
Reviewed-by: Michael Paquier &lt;michael.paquier@gmail.com&gt;
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
Reviewed-by: Michael Paquier &lt;michael.paquier@gmail.com&gt;
</pre>
</div>
</content>
</entry>
<entry>
<title>Fix busted markup.</title>
<updated>2015-03-03T04:28:31+00:00</updated>
<author>
<name>Tom Lane</name>
<email>tgl@sss.pgh.pa.us</email>
</author>
<published>2015-03-03T04:28:31+00:00</published>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/postgresql.git/commit/?id=d1479011744d80d80c669b5bd64dc32187f26c1e'/>
<id>d1479011744d80d80c669b5bd64dc32187f26c1e</id>
<content type='text'>
Evidently from commit 878fdcb843e087cc1cdeadc987d6ef55202ddd04.
Per buildfarm.
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
Evidently from commit 878fdcb843e087cc1cdeadc987d6ef55202ddd04.
Per buildfarm.
</pre>
</div>
</content>
</entry>
<entry>
<title>pgbench: Add a real expression syntax to \set</title>
<updated>2015-03-02T19:21:41+00:00</updated>
<author>
<name>Robert Haas</name>
<email>rhaas@postgresql.org</email>
</author>
<published>2015-03-02T19:21:41+00:00</published>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/postgresql.git/commit/?id=878fdcb843e087cc1cdeadc987d6ef55202ddd04'/>
<id>878fdcb843e087cc1cdeadc987d6ef55202ddd04</id>
<content type='text'>
Previously, you could do \set variable operand1 operator operand2, but
nothing more complicated.  Now, you can \set variable expression, which
makes it much simpler to do multi-step calculations here.  This also
adds support for the modulo operator (%), with the same semantics as in
C.

Robert Haas and Fabien Coelho, reviewed by Álvaro Herrera and
Stephen Frost
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
Previously, you could do \set variable operand1 operator operand2, but
nothing more complicated.  Now, you can \set variable expression, which
makes it much simpler to do multi-step calculations here.  This also
adds support for the modulo operator (%), with the same semantics as in
C.

Robert Haas and Fabien Coelho, reviewed by Álvaro Herrera and
Stephen Frost
</pre>
</div>
</content>
</entry>
<entry>
<title>Add --latency-limit option to pgbench.</title>
<updated>2014-10-13T17:50:24+00:00</updated>
<author>
<name>Heikki Linnakangas</name>
<email>heikki.linnakangas@iki.fi</email>
</author>
<published>2014-10-13T17:25:56+00:00</published>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/postgresql.git/commit/?id=98aed6c721763f2472ccd23b834baed9f83a944b'/>
<id>98aed6c721763f2472ccd23b834baed9f83a944b</id>
<content type='text'>
This allows transactions that take longer than specified limit to be counted
separately. With --rate, transactions that are already late by the time we
get to execute them are skipped altogether. Using --latency-limit with
--rate allows you to "catch up" more quickly, if there's a hickup in the
server causing a lot of transactions to stall momentarily.

Fabien COELHO, reviewed by Rukh Meski and heavily refactored by me.
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
This allows transactions that take longer than specified limit to be counted
separately. With --rate, transactions that are already late by the time we
get to execute them are skipped altogether. Using --latency-limit with
--rate allows you to "catch up" more quickly, if there's a hickup in the
server causing a lot of transactions to stall momentarily.

Fabien COELHO, reviewed by Rukh Meski and heavily refactored by me.
</pre>
</div>
</content>
</entry>
<entry>
<title>Change the way latency is calculated with pgbench --rate option.</title>
<updated>2014-09-11T09:57:32+00:00</updated>
<author>
<name>Heikki Linnakangas</name>
<email>heikki.linnakangas@iki.fi</email>
</author>
<published>2014-09-11T09:40:01+00:00</published>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/postgresql.git/commit/?id=02e3bcc661598275a75a8649b48602dca7aeec79'/>
<id>02e3bcc661598275a75a8649b48602dca7aeec79</id>
<content type='text'>
The reported latency values now include the "schedule lag" time, that is,
the time between the transaction's scheduled start time and the time it
actually started. This relates better to a model where requests arrive at a
certain rate, and we are interested in the response time to the end user or
application, rather than the response time of the database itself.

Also, when --rate is used, include the schedule lag time in the log output.

The --rate option is new in 9.4, so backpatch to 9.4. It seems better to
make this change in 9.4, while we're still in the beta period, than ship a
9.4 version that calculates the values differently than 9.5.
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
The reported latency values now include the "schedule lag" time, that is,
the time between the transaction's scheduled start time and the time it
actually started. This relates better to a model where requests arrive at a
certain rate, and we are interested in the response time to the end user or
application, rather than the response time of the database itself.

Also, when --rate is used, include the schedule lag time in the log output.

The --rate option is new in 9.4, so backpatch to 9.4. It seems better to
make this change in 9.4, while we're still in the beta period, than ship a
9.4 version that calculates the values differently than 9.5.
</pre>
</div>
</content>
</entry>
<entry>
<title>doc: Various typo/grammar fixes</title>
<updated>2014-08-30T15:52:36+00:00</updated>
<author>
<name>Kevin Grittner</name>
<email>kgrittn@postgresql.org</email>
</author>
<published>2014-08-30T15:52:36+00:00</published>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/postgresql.git/commit/?id=05258761bf12a64befc9caec1947b254cdeb74c5'/>
<id>05258761bf12a64befc9caec1947b254cdeb74c5</id>
<content type='text'>
Errors detected using Topy (https://github.com/intgr/topy), all
changes verified by hand and some manual tweaks added.

Marti Raudsepp

Individual changes backpatched, where applicable, as far as 9.0.
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
Errors detected using Topy (https://github.com/intgr/topy), all
changes verified by hand and some manual tweaks added.

Marti Raudsepp

Individual changes backpatched, where applicable, as far as 9.0.
</pre>
</div>
</content>
</entry>
<entry>
<title>docs: Add missing period.</title>
<updated>2014-08-14T19:19:43+00:00</updated>
<author>
<name>Robert Haas</name>
<email>rhaas@postgresql.org</email>
</author>
<published>2014-08-14T19:19:43+00:00</published>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/postgresql.git/commit/?id=751b7041050b7b19bf3001633740616089973ab3'/>
<id>751b7041050b7b19bf3001633740616089973ab3</id>
<content type='text'>
Fabien COELHO and Robert Haas
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
Fabien COELHO and Robert Haas
</pre>
</div>
</content>
</entry>
<entry>
<title>Fix typo in \setrandom document.</title>
<updated>2014-08-12T09:01:01+00:00</updated>
<author>
<name>Fujii Masao</name>
<email>fujii@postgresql.org</email>
</author>
<published>2014-08-12T09:01:01+00:00</published>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/postgresql.git/commit/?id=d6ded369a7793c926661f492c153a6dd05afc5bc'/>
<id>d6ded369a7793c926661f492c153a6dd05afc5bc</id>
<content type='text'>
Fabien COELHO
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
Fabien COELHO
</pre>
</div>
</content>
</entry>
<entry>
<title>pgbench: Allow \setrandom to generate Gaussian/exponential distributions.</title>
<updated>2014-07-30T17:22:08+00:00</updated>
<author>
<name>Robert Haas</name>
<email>rhaas@postgresql.org</email>
</author>
<published>2014-07-30T17:22:08+00:00</published>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/postgresql.git/commit/?id=ed802e7dc36059efbc6669b4bfeebad43f0898c1'/>
<id>ed802e7dc36059efbc6669b4bfeebad43f0898c1</id>
<content type='text'>
Mitsumasa KONDO and Fabien COELHO, with further wordsmithing by me.
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
Mitsumasa KONDO and Fabien COELHO, with further wordsmithing by me.
</pre>
</div>
</content>
</entry>
<entry>
<title>doc: Put new options in right order on reference pages</title>
<updated>2014-07-15T19:08:16+00:00</updated>
<author>
<name>Peter Eisentraut</name>
<email>peter_e@gmx.net</email>
</author>
<published>2014-07-15T18:34:33+00:00</published>
<link rel='alternate' type='text/html' href='http://trove.baserock.org/cgit/delta/postgresql.git/commit/?id=9a218c02b8f10bc5aa3a9227b0a30ad0b6bdf6a6'/>
<id>9a218c02b8f10bc5aa3a9227b0a30ad0b6bdf6a6</id>
<content type='text'>
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
</pre>
</div>
</content>
</entry>
</feed>
