@@ -541,15 +541,15 @@ pgbench <optional> <replaceable>options</replaceable> </optional> <replaceable>d
541
541
<firstterm>skipped</firstterm>.
542
542
</para>
543
543
<para>
544
- When the <option>--max-tries</option> option is used, the transaction with
545
- serialization or deadlock error cannot be retried if the total time of
546
- all its tries is greater than <replaceable>limit</replaceable> ms. To
547
- limit only the time of tries and not their number, use
548
- <literal>--max-tries=0</literal>. By default option
549
- <option>--max-tries</option> is set to 1 and transactions with
550
- serialization/deadlock errors are not retried. See <xref
551
- linkend="failures-and-retries"/> for more information about retrying
552
- such transactions.
544
+ When the <option>--max-tries</option> option is used, a transaction
545
+ which fails due to a serialization anomaly or from a deadlock will not
546
+ be retried if the total time of all its tries is greater than
547
+ <replaceable> limit</replaceable> ms. To limit only the time of tries
548
+ and not their number, use <literal>--max-tries=0</literal>. By
549
+ default, the option <option>--max-tries</option> is set to 1 and
550
+ transactions with serialization/deadlock errors are not retried. See
551
+ <xref linkend="failures-and-retries"/> for more information about
552
+ retrying such transactions.
553
553
</para>
554
554
</listitem>
555
555
</varlistentry>
@@ -622,7 +622,7 @@ pgbench <optional> <replaceable>options</replaceable> </optional> <replaceable>d
622
622
throttling (<option>-R</option>), the latency is computed with respect
623
623
to the transaction scheduled start time, not the actual transaction
624
624
beginning time, thus it also includes the average schedule lag time.
625
- When <option>--max-tries</option> is used to enable transactions retries
625
+ When <option>--max-tries</option> is used to enable transaction retries
626
626
after serialization/deadlock errors, the report includes the number of
627
627
retried transactions and the sum of all retries.
628
628
</para>
@@ -818,7 +818,7 @@ pgbench <optional> <replaceable>options</replaceable> </optional> <replaceable>d
818
818
<listitem>
819
819
<para>
820
820
Print messages about all errors and failures (errors without retrying)
821
- including which limit for retries was violated and how far it was
821
+ including which limit for retries was exceeded and how far it was
822
822
exceeded for the serialization/deadlock failures. (Note that in this
823
823
case the output can be significantly increased.).
824
824
See <xref linkend="failures-and-retries"/> for more information.
@@ -2433,7 +2433,7 @@ END;
2433
2433
</para>
2434
2434
2435
2435
<para>
2436
- If <option>--failures-detailed</option> option is used, the type of
2436
+ If the <option>--failures-detailed</option> option is used, the type of
2437
2437
failure is reported in the <replaceable>time</replaceable> like this:
2438
2438
<screen>
2439
2439
3 0 47423 0 1499414498 34501 3
@@ -2773,12 +2773,12 @@ statement latencies in milliseconds, failures and retries:
2773
2773
<listitem>
2774
2774
<para>
2775
2775
Errors of the main program. They are the most serious and always result
2776
- in an immediate exit from the <application>pgbench</application> with
2777
- the corresponding error message. They include:
2776
+ in an immediate exit from <application>pgbench</application> with the
2777
+ corresponding error message. They include:
2778
2778
<itemizedlist>
2779
2779
<listitem>
2780
2780
<para>
2781
- errors at the beginning of the <application>pgbench</application>
2781
+ errors at the beginning of <application>pgbench</application>
2782
2782
(e.g. an invalid option value);
2783
2783
</para>
2784
2784
</listitem>
@@ -2790,8 +2790,8 @@ statement latencies in milliseconds, failures and retries:
2790
2790
</listitem>
2791
2791
<listitem>
2792
2792
<para>
2793
- errors before starting threads (e.g. we could not connect to the
2794
- database server / the syntax error in the meta command / thread
2793
+ errors before starting threads (e.g. could not connect to the
2794
+ database server, syntax error in the meta command, thread
2795
2795
creation failure);
2796
2796
</para>
2797
2797
</listitem>
@@ -2813,7 +2813,7 @@ statement latencies in milliseconds, failures and retries:
2813
2813
</listitem>
2814
2814
<listitem>
2815
2815
<para>
2816
- Direct client errors. They lead to immediate exit from the
2816
+ Direct client errors. They lead to immediate exit from
2817
2817
<application>pgbench</application> with the corresponding error message
2818
2818
only in the case of an internal <application>pgbench</application>
2819
2819
error (which are supposed to never occur...). Otherwise in the worst
@@ -2829,11 +2829,11 @@ statement latencies in milliseconds, failures and retries:
2829
2829
</para>
2830
2830
2831
2831
<para>
2832
- Client 's run is aborted in case of a serious error, for example, the
2833
- connection with the database server was lost or the end of script reached
2834
- without completing the last transaction. In addition, if an execution of SQL
2832
+ A client 's run is aborted in case of a serious error; for example, the
2833
+ connection with the database server was lost or the end of script was reached
2834
+ without completing the last transaction. In addition, if execution of an SQL
2835
2835
or meta command fails for reasons other than serialization or deadlock errors,
2836
- the client is aborted. Otherwise, if an SQL fails with serialization or
2836
+ the client is aborted. Otherwise, if an SQL command fails with serialization or
2837
2837
deadlock errors, the client is not aborted. In such cases, the current
2838
2838
transaction is rolled back, which also includes setting the client variables
2839
2839
as they were before the run of this transaction (it is assumed that one
@@ -2845,21 +2845,21 @@ statement latencies in milliseconds, failures and retries:
2845
2845
time of retries (specified by the <option>--latency-limit</option> option) / the end
2846
2846
of benchmark (specified by the <option>--time</option> option). If
2847
2847
the last trial run fails, this transaction will be reported as failed but
2848
- the client is not aborted and continue to work.
2848
+ the client is not aborted and continues to work.
2849
2849
</para>
2850
2850
2851
2851
<note>
2852
2852
<para>
2853
- Without specifying the <option>--max-tries</option> option a transaction will
2853
+ Without specifying the <option>--max-tries</option> option, a transaction will
2854
2854
never be retried after a serialization or deadlock error because its default
2855
- values is 1. Use an unlimited number of tries (<literal>--max-tries=0</literal>)
2855
+ value is 1. Use an unlimited number of tries (<literal>--max-tries=0</literal>)
2856
2856
and the <option>--latency-limit</option> option to limit only the maximum time
2857
2857
of tries. You can also use the <option>--time</option> option to limit the
2858
2858
benchmark duration under an unlimited number of tries.
2859
2859
</para>
2860
2860
<para>
2861
2861
Be careful when repeating scripts that contain multiple transactions: the
2862
- script is always retried completely, so the successful transactions can be
2862
+ script is always retried completely, so successful transactions can be
2863
2863
performed several times.
2864
2864
</para>
2865
2865
<para>
@@ -2879,7 +2879,7 @@ statement latencies in milliseconds, failures and retries:
2879
2879
<para>
2880
2880
The main report contains the number of failed transactions. If the
2881
2881
<option>--max-tries</option> option is not equal to 1, the main report also
2882
- contains the statistics related to retries: the total number of retried
2882
+ contains statistics related to retries: the total number of retried
2883
2883
transactions and total number of retries. The per-script report inherits all
2884
2884
these fields from the main report. The per-statement report displays retry
2885
2885
statistics only if the <option>--max-tries</option> option is not equal to 1.
@@ -2890,7 +2890,7 @@ statement latencies in milliseconds, failures and retries:
2890
2890
aggregation logs, as well as in the main and per-script reports, use the
2891
2891
<option>--failures-detailed</option> option. If you also want to distinguish
2892
2892
all errors and failures (errors without retrying) by type including which
2893
- limit for retries was violated and how far it was exceeded for the
2893
+ limit for retries was exceeded and how much it was exceeded by for the
2894
2894
serialization/deadlock failures, use the <option>--verbose-errors</option>
2895
2895
option.
2896
2896
</para>
0 commit comments