Commitc9193a1

akorotkov

authored and

pull[bot]

committed

Document the ability to specify TableAM for pgbench

Upcoming custom Table Access Methods (TableAM) need benchmarking. Despitepgbench doesn't have an explicit option for TableAM specification, one canspecify it using PGOPTION environmental variable. The present commit documentsthis way to specify TableAM for pgbench.Discussion:https://postgr.es/m/CAC77N6ih%3DLbhZQXV76grEsaVQkBL464Y2Foqq9o%3Df4UBfEOfEQ%40mail.gmail.comAuthor: Michel Pelletier, Alexander KorotkovReviewed-by: Justin Pryzby, Mason Sharp, Michael Paquier

1 parent2af1e13 commitc9193a1Copy full SHA for c9193a1

File tree

2 files changed

+17

-1

lines changed

doc/src/sgml
- config.sgml
- ref
  - pgbench.sgml

2 files changed

+17

-1

lines changed

`‎doc/src/sgml/config.sgml`

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -317,7 +317,7 @@ UPDATE pg_settings SET setting = reset_val WHERE name = 'configuration_parameter`
`317`	`317`
`318`	`318`	`</sect2>`
`319`	`319`
`320`		`- <sect2>`
	`320`	`+ <sect2 id="config-setting-shell">`
`321`	`321`	`<title>Parameter Interaction via the Shell</title>`
`322`	`322`
`323`	`323`	`<para>`

`‎doc/src/sgml/ref/pgbench.sgml`

Lines changed: 16 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -2887,6 +2887,22 @@ statement latencies in milliseconds, failures and retries:`
`2887`	`2887`	`</para>`
`2888`	`2888`	`</refsect2>`
`2889`	`2889`
	`2890`	`+ <refsect2>`
	`2891`	`+ <title>Table Access Methods</title>`
	`2892`	`+`
	`2893`	`+ <para>`
	`2894`	`+ You may specify the <link linkend="tableam">Table Access Method</link>`
	`2895`	`+ for the pgbench tables. The environment variable <envar>PGOPTIONS</envar>`
	`2896`	`+ specifies database configuration options that are passed to PostgreSQL via`
	`2897`	`+ the command line (See <xref linkend="config-setting-shell"/>).`
	`2898`	`+ For example, a hypothetical default Table Access Method for the tables that`
	`2899`	`+ pgbench creates called <literal>wuzza</literal> can be specified with:`
	`2900`	`+<programlisting>`
	`2901`	`+PGOPTIONS='-c default_table_access_method=wuzza'`
	`2902`	`+</programlisting>`
	`2903`	`+ </para>`
	`2904`	`+ </refsect2>`
	`2905`	`+`
`2890`	`2906`	`<refsect2>`
`2891`	`2907`	`<title>Good Practices</title>`
`2892`	`2908`

0 commit comments

Comments

(0)

Movatterモバイル変換

Navigation Menu

Search code, repositories, users, issues, pull requests...

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Commitc9193a1

File tree

2 files changed

2 files changed

`‎doc/src/sgml/config.sgml`

`‎doc/src/sgml/ref/pgbench.sgml`

0 commit comments