diff options
author | Bruce Momjian <bruce@momjian.us> | 2022-07-08 18:36:27 -0400 |
---|---|---|
committer | Bruce Momjian <bruce@momjian.us> | 2022-07-08 18:36:27 -0400 |
commit | 12f56b6a70ca06acd394f37a965e4814e8472373 (patch) | |
tree | df590e96ad2b08123b0f4cd3a66695c4d3db278e | |
parent | f890223bc3c45f78774d9b042b62f529eb434aa9 (diff) | |
download | postgresql-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.sgml | 13 |
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> |