forked from docs/doc-exports
luhuayi
177cd61a57
Reviewed-by: Pruthi, Vineet <vineet.pruthi@t-systems.com> Co-authored-by: luhuayi <luhuayi@huawei.com> Co-committed-by: luhuayi <luhuayi@huawei.com>
18 lines
2.3 KiB
HTML
18 lines
2.3 KiB
HTML
<a name="EN-US_TOPIC_0000001811609813"></a><a name="EN-US_TOPIC_0000001811609813"></a>
|
|
|
|
<h1 class="topictitle1">Checkpoints</h1>
|
|
<div id="body8662426"><div class="section" id="EN-US_TOPIC_0000001811609813__sd7daa0171e7245968cf6a44d968e1ad5"><h4 class="sectiontitle">checkpoint_segments</h4><p id="EN-US_TOPIC_0000001811609813__af3ffa17bd23a420e8eaf66f29998b87d"><strong id="EN-US_TOPIC_0000001811609813__b413515622217">Parameter description</strong>: minimum number of WAL segment files in the period specified by <strong id="EN-US_TOPIC_0000001811609813__b1292126152316">checkpoint_timeout</strong>. The size of each log file is 16 MB.</p>
|
|
<p id="EN-US_TOPIC_0000001811609813__p4873133064319"><strong id="EN-US_TOPIC_0000001811609813__b162513720243">Type</strong>: SIGHUP</p>
|
|
<p id="EN-US_TOPIC_0000001811609813__af6e4fb5b24d14955a064663ccc00bc45"><strong id="EN-US_TOPIC_0000001811609813__b29895242">Value range</strong>: an integer. The minimum value is <strong id="EN-US_TOPIC_0000001811609813__b47201151142917">1</strong>.</p>
|
|
<p id="EN-US_TOPIC_0000001811609813__a28ba2b4d59dd444bb97cd0ad17f80017"><strong id="EN-US_TOPIC_0000001811609813__b2001761434101525">Default value</strong>: <strong id="EN-US_TOPIC_0000001811609813__b318163230101525">64</strong></p>
|
|
<div class="notice" id="EN-US_TOPIC_0000001811609813__note0657113584916"><span class="noticetitle"><img src="public_sys-resources/notice_3.0-en-us.png"> </span><div class="noticebody"><p id="EN-US_TOPIC_0000001811609813__p16571235194915">Increasing the value of this parameter speeds up the import of big data. Set this parameter based on <strong id="EN-US_TOPIC_0000001811609813__b1595291132316">checkpoint_timeout</strong> and <strong id="EN-US_TOPIC_0000001811609813__b18953141102314">shared_buffers</strong>. This parameter affects the number of WAL log segment files that can be reused. Generally, the maximum number of reused files in the <strong id="EN-US_TOPIC_0000001811609813__b123561159366">pg_xlog</strong> folder is twice the number of checkpoint segments. The reused files are not deleted and are renamed to the WAL log segment files which will be later used.</p>
|
|
</div></div>
|
|
</div>
|
|
</div>
|
|
<div>
|
|
<div class="familylinks">
|
|
<div class="parentlink"><strong>Parent topic:</strong> <a href="dws_04_0900.html">Write Ahead Logs</a></div>
|
|
</div>
|
|
</div>
|
|
|