doc: pg_prewarm add configuration example

Started by Dong Wook Leeover 3 years ago3 messages
#1Dong Wook Lee
sh95119@gmail.com
1 attachment(s)

Hi hackers,

I thought it would be nice to have an configuration example of the pg_prewarm extension.
Therefore, I have written an example of a basic configuration.

---
Regards,
DongWook Lee

Attachments:

001_doc_pg_prewarm.patchtext/x-diff; charset=us-asciiDownload
diff --git a/doc/src/sgml/pgprewarm.sgml b/doc/src/sgml/pgprewarm.sgml
index 4e68812250..754a21a076 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 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>
 
#2Dong Wook Lee
sh95119@gmail.com
In reply to: Dong Wook Lee (#1)
Re: doc: pg_prewarm add configuration example

On 22/06/29 03:57오후, Jacob Champion wrote:

On 6/18/22 01:55, Dong Wook Lee wrote:

Hi hackers,

I thought it would be nice to have an configuration example of the pg_prewarm extension.
Therefore, I have written an example of a basic configuration.

[offlist]

Hi Dong Wook, I saw a commitfest entry registered for some of your other
patches, but not for this one. Quick reminder to register it in the
Documentation section if that was your intent.

Thank you very much for letting me know.
The patch is so trivial that I thought about whether to post it on commitfest,
but I think it would be better to post it.

Show quoted text

Thanks,
--Jacob

[NOTE] This is part of a mass communication prior to the July
commitfest, which begins in two days. If I've made a mistake -- for
example, if the patch has already been registered, withdrawn, or
committed -- just let me know, and sorry for the noise.

#3Bruce Momjian
bruce@momjian.us
In reply to: Dong Wook Lee (#2)
Re: doc: pg_prewarm add configuration example

On Thu, Jun 30, 2022 at 02:40:50PM +0900, Dong Wook Lee wrote:

On 22/06/29 03:57오후, Jacob Champion wrote:

On 6/18/22 01:55, Dong Wook Lee wrote:

Hi hackers,

I thought it would be nice to have an configuration example of the pg_prewarm extension.
Therefore, I have written an example of a basic configuration.

[offlist]

Hi Dong Wook, I saw a commitfest entry registered for some of your other
patches, but not for this one. Quick reminder to register it in the
Documentation section if that was your intent.

Thank you very much for letting me know.
The patch is so trivial that I thought about whether to post it on commitfest,
but I think it would be better to post it.

I have applied this, with adjustments, to all supported versions back to
PG 11. PG 10 had docs different enough that I skipped it.

--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EDB https://enterprisedb.com

Indecision is a decision. Inaction is an action. Mark Batterson