pgsql: pgbench: Add --continue-on-error option. - Mailing list pgsql-committers

From Fujii Masao
Subject pgsql: pgbench: Add --continue-on-error option.
Date
Msg-id E1vHJZh-005R7k-19@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
pgbench: Add --continue-on-error option.

This commit adds the --continue-on-error option, allowing pgbench clients
to continue running even when SQL statements fail for reasons other than
serialization or deadlock errors. Without this option (by default),
the clients aborts in such cases, which was the only available behavior
previously.

This option is useful for benchmarks using custom scripts that may
raise errors, such as unique constraint violations, where users want
pgbench to complete the run despite individual statement failures.

Author: Rintaro Ikeda <ikedarintarof@oss.nttdata.com>
Co-authored-by: Yugo Nagata <nagata@sraoss.co.jp>
Co-authored-by: Fujii Masao <masao.fujii@gmail.com>
Reviewed-by: Stepan Neretin <slpmcf@gmail.com>
Reviewed-by: Matthias van de Meent <boekewurm+postgres@gmail.com>
Reviewed-by: Dilip Kumar <dilipbalaut@gmail.com>
Reviewed-by: Srinath Reddy Sadipiralla <srinath2133@gmail.com>
Reviewed-by: Hayato Kuroda <kuroda.hayato@fujitsu.com>
Reviewed-by: Anthonin Bonnefoy <anthonin.bonnefoy@datadoghq.com>
Reviewed-by: Chao Li <lic@highgo.com>
Discussion: https://postgr.es/m/44334231a4d214fac382a69cceb7d9fc@oss.nttdata.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/0ab208fa505c04e2b3483de53a73edb71f9b9106

Modified Files
--------------
doc/src/sgml/ref/pgbench.sgml                |  65 ++++++++++++---
src/bin/pgbench/pgbench.c                    | 117 ++++++++++++++++++++++-----
src/bin/pgbench/t/001_pgbench_with_server.pl |  22 +++++
3 files changed, 171 insertions(+), 33 deletions(-)


pgsql-committers by date:

Previous
From: Peter Eisentraut
Date:
Subject: pgsql: Fix "inconsistent DLL linkage" warning on Windows MSVC
Next
From: Daniel Gustafsson
Date:
Subject: pgsql: doc: Fix incorrect wording for --file in pg_dump