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
commit0a1c5a6b966782e4f2de67a3613dae7c5880dd83 (patch)
tree3231e32a0558a0928297d6c2a822d720ac38e18e
parenta2996478c32d27171a786f59eff0505b1722b9ea (diff)
downloadpostgresql-0a1c5a6b966782e4f2de67a3613dae7c5880dd83.tar.gz
postgresql-0a1c5a6b966782e4f2de67a3613dae7c5880dd83.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 4e68812250e..754a21a076c 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>