postgres.git / summary / log / commit / refs

commit    f77ff083350eb5a2625a4dbfca61d15b66c4918b
Author:   Alexander Korotkov <akorotkov@postgresql.org>
Date:     Wed Jul 20 12:44:44 2022 +0000
First released in: 16.0

    Document the ability to specify TableAM for pgbench
    
    Upcoming custom Table Access Methods (TableAM) need benchmarking.  Despite
    pgbench doesn't have an explicit option for TableAM specification, one can
    specify it using PGOPTION environmental variable.  The present commit documents
    this way to specify TableAM for pgbench.
    
    Discussion: https://postgr.es/m/CAC77N6ih%3DLbhZQXV76grEsaVQkBL464Y2Foqq9o%3Df4UBfEOfEQ%40mail.gmail.com
    Author: Michel Pelletier, Alexander Korotkov
    Reviewed-by: Justin Pryzby, Mason Sharp, Michael Paquier


 doc/src/sgml/config.sgml      |  2 +-
 doc/src/sgml/ref/pgbench.sgml | 16 ++++++++++++++++
 2 files changed, 17 insertions(+), 1 deletion(-)

diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml
index 37fd80388c0..e2d728e0c4f 100644
--- a/doc/src/sgml/config.sgml
+++ b/doc/src/sgml/config.sgml
@@ -317,7 +317,7 @@ UPDATE pg_settings SET setting = reset_val WHERE name = 'configuration_parameter
 
    </sect2>
 
-   <sect2>
+   <sect2 id="config-setting-shell">
     <title>Parameter Interaction via the Shell</title>
 
      <para>
diff --git a/doc/src/sgml/ref/pgbench.sgml b/doc/src/sgml/ref/pgbench.sgml
index 2acf55c2acd..1a1be489e7e 100644
--- a/doc/src/sgml/ref/pgbench.sgml
+++ b/doc/src/sgml/ref/pgbench.sgml
@@ -2887,6 +2887,22 @@ statement latencies in milliseconds, failures and retries:
   </para>
  </refsect2>
 
+ <refsect2>
+  <title>Table Access Methods</title>
+
+  <para>
+   You may specify the <link linkend="tableam">Table Access Method</link>
+   for the pgbench tables.  The environment variable <envar>PGOPTIONS</envar>
+   specifies database configuration options that are passed to PostgreSQL via
+   the command line (See <xref linkend="config-setting-shell"/>).
+   For example, a hypothetical default Table Access Method for the tables that
+   pgbench creates called <literal>wuzza</literal> can be specified with:
+<programlisting>
+PGOPTIONS='-c default_table_access_method=wuzza'
+</programlisting>
+  </para>
+ </refsect2>
+
  <refsect2>
   <title>Good Practices</title>
 


[parent: bcedd8f5fce0]