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 | aa31b29375b9afbe1330d7726855645ff82a2e51 (patch) | |
| tree | 098c2818540600bdc80d132ae2bfb2d8463d5677 | |
| parent | e57519a4637a8d88ae993ac1273d2b59d03a0f75 (diff) | |
| download | postgresql-aa31b29375b9afbe1330d7726855645ff82a2e51.tar.gz postgresql-aa31b29375b9afbe1330d7726855645ff82a2e51.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 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> |