aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorBruce Momjian <bruce@momjian.us>2022-07-08 18:36:27 -0400
committerBruce Momjian <bruce@momjian.us>2022-07-08 18:36:27 -0400
commit12f56b6a70ca06acd394f37a965e4814e8472373 (patch)
treedf590e96ad2b08123b0f4cd3a66695c4d3db278e
parentf890223bc3c45f78774d9b042b62f529eb434aa9 (diff)
downloadpostgresql-12f56b6a70ca06acd394f37a965e4814e8472373.tar.gz
postgresql-12f56b6a70ca06acd394f37a965e4814e8472373.zip
doc: add pg_prewarm example
Discussion: https://postgr.es/m/20220618085541.ezxdaljlpo6x7msc@home-desktop Author: Dong Wook Lee Backpatch-through: 11
-rw-r--r--doc/src/sgml/pgprewarm.sgml13
1 files changed, 13 insertions, 0 deletions
diff --git a/doc/src/sgml/pgprewarm.sgml b/doc/src/sgml/pgprewarm.sgml
index 51afc5df3f5..dc26d08805d 100644
--- a/doc/src/sgml/pgprewarm.sgml
+++ b/doc/src/sgml/pgprewarm.sgml
@@ -121,6 +121,19 @@ autoprewarm_dump_now() RETURNS int8
</listitem>
</varlistentry>
</variablelist>
+ <para>
+ These parameters must be set in <filename>postgresql.conf</filename>.
+ Typical usage might be:
+ </para>
+
+<programlisting>
+# postgresql.conf
+shared_preload_libraries = 'pg_prewarm'
+
+pg_prewarm.autoprewarm = true
+pg_prewarm.autoprewarm_interval = 300s
+
+</programlisting>
</sect2>