Commitdafae97

committed

Fix recovery_prefetch docs.

Correct a typo and a couple of sentences that weren't updated to reflectrecent changes to the code.Reported-by: Justin Pryzby <pryzby@telsasoft.com>Discussion:https://postgr.es/m/20220407125555.GC24419%40telsasoft.com

1 parentd6c0db1 commitdafae97Copy full SHA for dafae97

File tree

-8

lines changed

-8

lines changed

Lines changed: 3 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -3685,8 +3685,9 @@ include_dir 'conf.d'`
`3685`	`3685`	`<para>`
`3686`	`3686`	`Whether to try to prefetch blocks that are referenced in the WAL that`
`3687`	`3687`	`are not yet in the buffer pool, during recovery. Valid values are`
`3688`		`- <literal>off</literal> (the default), <literal>on</literal> and`
`3689`		`- <literal>try</literal>. The setting <literal>try</literal> enables`
	`3688`	`+ <literal>off</literal>, <literal>on</literal> and`
	`3689`	`+ <literal>try</literal> (the default). The setting`
	`3690`	`+ <literal>try</literal> enables`
`3690`	`3691`	`prefetching only if the operating system provides the`
`3691`	`3692`	`<function>posix_fadvise</function> function, which is currently used`
`3692`	`3693`	`to implement prefetching. Note that some operating systems provide the`

Lines changed: 3 additions & 5 deletions

Original file line number	Diff line number	Diff line change
`@@ -3049,11 +3049,9 @@ SELECT pid, wait_event_type, wait_event FROM pg_stat_activity WHERE wait_event i`
`3049`	`3049`
`3050`	`3050`	`<para>`
`3051`	`3051`	`The <structname>pg_stat_recovery_prefetch</structname> view will contain`
`3052`		`- only one row. It is filled with nulls if recovery has not run or`
`3053`		`- <xref linkend="guc-recovery-prefetch"/> is not enabled. The`
`3054`		`- columns <structfield>wal_distance</structfield>,`
`3055`		`- <structfield>block_distance</structfield>`
`3056`		`- and <structfield>io_depth</structfield> show current values, and the`
	`3052`	`+ only one row. The columns <structfield>wal_distance</structfield>,`
	`3053`	`+ <structfield>block_distance</structfield> and`
	`3054`	`+ <structfield>io_depth</structfield> show current values, and the`
`3057`	`3055`	`other columns show cumulative counters that can be reset`
`3058`	`3056`	`with the <function>pg_stat_reset_shared</function> function.`
`3059`	`3057`	`</para>`

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -812,7 +812,7 @@`
`812`	`812`	`The <xref linkend="guc-maintenance-io-concurrency"/> and`
`813`	`813`	`<xref linkend="guc-wal-decode-buffer-size"/> settings limit prefetching`
`814`	`814`	`concurrency and distance, respectively. By default, it is set to`
`815`		`- <literal>try</literal>, whichenabled the feature on systems where`
	`815`	`+ <literal>try</literal>, whichenables the feature on systems where`
`816`	`816`	`<function>posix_fadvise</function> is available.`
`817`	`817`	`</para>`
`818`	`818`	`</sect1>`

Comments

(0)