doc-exports/docs/dws/dev/dws_04_0945.html

<a name="EN-US_TOPIC_0000001811490665"></a><a name="EN-US_TOPIC_0000001811490665"></a>

<h1 class="topictitle1">Miscellaneous Parameters</h1>
<div id="body8662426"><div class="section" id="EN-US_TOPIC_0000001811490665__s0fded4d62ed54c94b6d6d111e9b3b7eb"><h4 class="sectiontitle">enable_cluster_resize</h4><p id="EN-US_TOPIC_0000001811490665__ae5908dee457944949f5967fb4a010379"><strong id="EN-US_TOPIC_0000001811490665__b1894173183419">Parameter description</strong>: Indicates whether the current session is for scaling or redistributing data. It should only be used for these specific sessions and not set for other service sessions.</p>
<p id="EN-US_TOPIC_0000001811490665__p149848194914"><strong id="EN-US_TOPIC_0000001811490665__b11256251104916">Type</strong>: SUSET</p>
<p id="EN-US_TOPIC_0000001811490665__a2ab2b2d121004011bcba11d075b620a3"><strong id="EN-US_TOPIC_0000001811490665__en-us_topic_0059778487_aa1fc9bedad6b4779a216c176c5046dcc">Value range</strong>: Boolean</p>
<ul id="EN-US_TOPIC_0000001811490665__ua9d8c0ff3f13472191c3ca67e920c311"><li id="EN-US_TOPIC_0000001811490665__ld7b8ad04fd604925b1e288a5383e8de7"><strong id="EN-US_TOPIC_0000001811490665__b322032110359">on</strong> indicates that the current session is for scaling or redistributing data, and allows the execution of specific SQL statements for redistribution.</li><li id="EN-US_TOPIC_0000001811490665__l0e6d6cc21f6e476cbb2f7814e84b379f"><strong id="EN-US_TOPIC_0000001811490665__b47391356123514">off</strong> indicates that the current session is not for scaling or redistributing data, and does not allow the execution of specific SQL statements for redistribution.</li></ul>
<p id="EN-US_TOPIC_0000001811490665__a6d5cfc52a52f47e19fc3c5a605a1f78d"><strong id="EN-US_TOPIC_0000001811490665__en-us_topic_0059778487_en-us_topic_0058967649_b42645073104244_2">Default value</strong>: <strong id="EN-US_TOPIC_0000001811490665__en-us_topic_0059778487_en-us_topic_0058967649_b842352706195053">off</strong></p>
<div class="note" id="EN-US_TOPIC_0000001811490665__note391513091717"><img src="public_sys-resources/note_3.0-en-us.png"><span class="notetitle"> </span><div class="notebody"><p id="EN-US_TOPIC_0000001811490665__p17915308174">This parameter is used for internal O&amp;M. Do not set it to <strong id="EN-US_TOPIC_0000001811490665__b1356771143911">on</strong> unless absolutely necessary.</p>
</div></div>
</div>
<div class="section" id="EN-US_TOPIC_0000001811490665__s6fae1b61ff194289a379a299ff677d43"><h4 class="sectiontitle">dfs_partition_directory_length</h4><p id="EN-US_TOPIC_0000001811490665__a4614e313edd84cae851ca638742672e3"><strong id="EN-US_TOPIC_0000001811490665__aa42b93eff6494c03a473fcdffc0d5f03">Parameter description</strong>: Specifies the largest directory name length for the partition directory of a table partitioned by VALUE in the HDFS.</p>
<p id="EN-US_TOPIC_0000001811490665__p88251145134520"><strong id="EN-US_TOPIC_0000001811490665__b940185618492">Type</strong>: USERSET</p>
<p id="EN-US_TOPIC_0000001811490665__ae933c2ed729b470d90ae478915726d12"><strong id="EN-US_TOPIC_0000001811490665__en-us_topic_0059778487_en-us_topic_0058967649_b4378215721916">Value range</strong>: 92 to 7999</p>
<p id="EN-US_TOPIC_0000001811490665__a99a2833ba9f349d6b4c1d61a67ed2961"><strong id="EN-US_TOPIC_0000001811490665__en-us_topic_0059778487_en-us_topic_0058967649_b37427418113820">Default value</strong>: <strong id="EN-US_TOPIC_0000001811490665__en-us_topic_0059778487_en-us_topic_0058967649_b842352706195139">512</strong></p>
</div>
<div class="section" id="EN-US_TOPIC_0000001811490665__s21663391021e43df87e07dd32b06fab5"><h4 class="sectiontitle">enable_hadoop_env</h4><p id="EN-US_TOPIC_0000001811490665__a615fa8e08cad4169ba48f1df817d8607"><strong id="EN-US_TOPIC_0000001811490665__b964010596210">Parameter description</strong>: Sets whether local row- and column-store tables can be created in a database while the Hadoop feature is used. In the <span id="EN-US_TOPIC_0000001811490665__text1678142882">GaussDB(DWS)</span> cluster, it is set to <strong id="EN-US_TOPIC_0000001811490665__en-us_topic_0085032935_b84235270614431">off</strong> by default to support local row- and column- based storage and cross-cluster access to Hadoop. You are not advised to change the value of this parameter.</p>
<p id="EN-US_TOPIC_0000001811490665__p485195611459"><strong id="EN-US_TOPIC_0000001811490665__b1358125611490">Type</strong>: USERSET</p>
<p id="EN-US_TOPIC_0000001811490665__a79b3b2d4fc7e45f1812f3493319dad8a"><strong id="EN-US_TOPIC_0000001811490665__en-us_topic_0059778487_b2003456202826">Value range</strong>: Boolean</p>
<ul id="EN-US_TOPIC_0000001811490665__u4397de177dca4db69f0bd81398f6668a"><li id="EN-US_TOPIC_0000001811490665__l167f6b47312949f6b5ff949843889bc8"><strong id="EN-US_TOPIC_0000001811490665__b842352706145621">on</strong> or <strong id="EN-US_TOPIC_0000001811490665__b842352706145624">true</strong>, indicating that local row- and column-store tables cannot be created in a database while the Hadoop feature is used.</li><li id="EN-US_TOPIC_0000001811490665__l917b4888053848abb79b4d53a0da2364"><strong id="EN-US_TOPIC_0000001811490665__b19917131116319">off</strong> or <strong id="EN-US_TOPIC_0000001811490665__b139221211838">false</strong>, indicating that local row- and column-based tables can be created in a database while the Hadoop feature is used.</li></ul>
<p id="EN-US_TOPIC_0000001811490665__a344a442189e142b59f3e8d47a3c7a09b"><strong id="EN-US_TOPIC_0000001811490665__b59975128311">Default value</strong>: <strong id="EN-US_TOPIC_0000001811490665__b11997121212314">off</strong></p>
</div>
<div class="section" id="EN-US_TOPIC_0000001811490665__s8bf53df890a74d4f965fe0f58ad3ca85"><h4 class="sectiontitle">enable_upgrade_merge_lock_mode</h4><p id="EN-US_TOPIC_0000001811490665__a2856039ebd794c688bd68c4735890a21"><strong id="EN-US_TOPIC_0000001811490665__en-us_topic_0059778487_en-us_topic_0058967649_b842352706195430">Parameter description</strong>: If this parameter is set to <strong id="EN-US_TOPIC_0000001811490665__en-us_topic_0059778487_en-us_topic_0058967649_b637250170164027">on</strong>, the delta merge operation internally increases the lock level, and errors can be avoided when update and delete operations are performed at the same time.</p>
<p id="EN-US_TOPIC_0000001811490665__p442115222533"><strong id="EN-US_TOPIC_0000001811490665__b127018586498">Type</strong>: USERSET</p>
<p id="EN-US_TOPIC_0000001811490665__aabbccaa23ee74b248d5a4d5058bd8bd0"><strong id="EN-US_TOPIC_0000001811490665__en-us_topic_0059778487_en-us_topic_0058967649_b466774510813">Value range</strong>: Boolean</p>
<ul id="EN-US_TOPIC_0000001811490665__u2b4543a180ad4ddb93dd9e00df3d8860"><li id="EN-US_TOPIC_0000001811490665__l55b963d7e56546bd97835c44632ee186">If this parameter is set to <strong id="EN-US_TOPIC_0000001811490665__en-us_topic_0059778487_en-us_topic_0058967649_b175332126164021">on</strong>, the delta merge operation internally increases the lock level. In this way, when any two of the <strong id="EN-US_TOPIC_0000001811490665__b156647084292858">DELTAMERGE</strong>, <strong id="EN-US_TOPIC_0000001811490665__b192680440792858">UPDATE</strong>, and <strong id="EN-US_TOPIC_0000001811490665__b8416614692858">DELETE</strong> operations are concurrently performed, an operation can be performed only after the previous one is complete.</li><li id="EN-US_TOPIC_0000001811490665__l3af59e51552042f793c0adfdb594b55a">If this parameter is set to <strong id="EN-US_TOPIC_0000001811490665__b120717468692932">off</strong>, and any two of the <strong id="EN-US_TOPIC_0000001811490665__b109305566492932">DELTAMERGE</strong>, <strong id="EN-US_TOPIC_0000001811490665__b45861486792932">UPDATE</strong>, and <strong id="EN-US_TOPIC_0000001811490665__b125889858692932">DELETE</strong> operations are concurrently performed to data in a row in the delta table of the HDFS table, errors will be reported during the later operation, and the operation will stop.</li></ul>
<p id="EN-US_TOPIC_0000001811490665__ac9ebeed42c7a48078b50e92687413a52"><strong id="EN-US_TOPIC_0000001811490665__b352906995">Default value</strong>: <strong id="EN-US_TOPIC_0000001811490665__b758149175">off</strong></p>
</div>
<div class="section" id="EN-US_TOPIC_0000001811490665__s0442694c0bad43cc844a509bb4e35c92"><h4 class="sectiontitle">job_queue_processes</h4><p id="EN-US_TOPIC_0000001811490665__a497063e038a94b90b9766595021bfc0d"><strong id="EN-US_TOPIC_0000001811490665__en-us_topic_0059778487_b84235270691737">Parameter description</strong>: Specifies the number of jobs that can be concurrently executed.</p>
<p id="EN-US_TOPIC_0000001811490665__p7926164184414"><strong id="EN-US_TOPIC_0000001811490665__b1824712592493">Type</strong>: POSTMASTER</p>
<p id="EN-US_TOPIC_0000001811490665__a6cbb827a1c4148e6942d0f6c952ded6a"><strong id="EN-US_TOPIC_0000001811490665__en-us_topic_0059778487_en-us_topic_0058967753_b66499804">Value range</strong>: 0 to 1000</p>
<p id="EN-US_TOPIC_0000001811490665__a47918790a4004bd0b703c818e817c95b"><strong id="EN-US_TOPIC_0000001811490665__b842352706171440">Functions</strong>:</p>
<ul id="EN-US_TOPIC_0000001811490665__ufe664f54755546c5ad8a08c56a2a0f35"><li id="EN-US_TOPIC_0000001811490665__l9a8eb7e2f25e47ee9914685c6e4f79f8">Setting <strong id="EN-US_TOPIC_0000001811490665__en-us_topic_0059778487_b84235270694029">job_queue_processes</strong> to <strong id="EN-US_TOPIC_0000001811490665__en-us_topic_0059778487_b84235270694035">0</strong> indicates that the scheduled task function is disabled and that no job will be executed. (Enabling scheduled tasks may affect the system performance. At sites where this function is not required, you are advised to disable it.)</li><li id="EN-US_TOPIC_0000001811490665__l0ce82cab58dd499ca1cd025c94f02dcb">Setting <strong id="EN-US_TOPIC_0000001811490665__b161033785893659">job_queue_processes</strong> to a value that is greater than <strong id="EN-US_TOPIC_0000001811490665__b202213719793659">0</strong> indicates that the scheduled task function is enabled and this value is the maximum number of tasks that can be concurrently processed.</li></ul>
<p id="EN-US_TOPIC_0000001811490665__en-us_topic_0059778487_p345709639356">After the scheduled task function is enabled, the <strong id="EN-US_TOPIC_0000001811490665__b1756916185343">job_scheduler</strong> thread at a scheduled interval polls the <strong id="EN-US_TOPIC_0000001811490665__en-us_topic_0059778487_b84235270610344">pg_jobs</strong> system catalog. The scheduled task check is performed every second by default.</p>
<p id="EN-US_TOPIC_0000001811490665__en-us_topic_0059778487_p427032159356">Too many concurrent tasks consume many system resources, so you need to set the number of concurrent tasks to be processed. If the current number of concurrent tasks reaches <strong id="EN-US_TOPIC_0000001811490665__en-us_topic_0059778487_b84235270610226">job_queue_processes</strong> and some of them expire, these tasks will be postponed to the next polling period. Therefore, you are advised to set the polling interval (the <strong id="EN-US_TOPIC_0000001811490665__b15234113313373">interval</strong> parameter of the <strong id="EN-US_TOPIC_0000001811490665__b1323519337370">submit</strong> API) based on the execution duration of each task to avoid the problem that tasks in the next polling period cannot be properly processed because overlong task execution time.</p>
<p id="EN-US_TOPIC_0000001811490665__a9053ca59af6842659297113b7f03ff9e">Note: If the number of parallel jobs is large and the value is too small, these jobs will wait in queues. However, a large parameter value leads to large resource consumption. You are advised to set this parameter to <strong id="EN-US_TOPIC_0000001811490665__en-us_topic_0059778487_b11879427091853">100</strong> and change it based on the system resource condition.</p>
<p id="EN-US_TOPIC_0000001811490665__acc823d90efbe4d518dfdf1959589934c"><strong id="EN-US_TOPIC_0000001811490665__en-us_topic_0059778487_a69c0ed76f7a6489cbb26a65ec66507af">Default value</strong>: <strong id="EN-US_TOPIC_0000001811490665__en-us_topic_0059778487_b842352706201318">10</strong></p>
</div>
<div class="section" id="EN-US_TOPIC_0000001811490665__s4e676820997f4234ae5d3c355c905e7e"><h4 class="sectiontitle">ngram_gram_size</h4><p id="EN-US_TOPIC_0000001811490665__a647022da78774ba7a3e9e98ff770b9a3"><strong id="EN-US_TOPIC_0000001811490665__en-us_topic_0059778487_b842352706145043">Parameter description</strong>: Specifies the length of the ngram parser segmentation.</p>
<p id="EN-US_TOPIC_0000001811490665__p1216912335537"><strong id="EN-US_TOPIC_0000001811490665__b0488115944911">Type</strong>: USERSET</p>
<p id="EN-US_TOPIC_0000001811490665__a3b7bfed6b2de4e1cab833214bff5fd16"><strong id="EN-US_TOPIC_0000001811490665__en-us_topic_0059778487_a1f68b0520df241448235cf649c501dd3">Value range</strong>: an integer ranging from 1 to 4</p>
<p id="EN-US_TOPIC_0000001811490665__aa51895dbdb7f43248e71e7cf1aefd3c2"><strong id="EN-US_TOPIC_0000001811490665__en-us_topic_0059778487_b60432567164116">Default value</strong>: <strong id="EN-US_TOPIC_0000001811490665__b84235270617214">2</strong></p>
</div>
<div class="section" id="EN-US_TOPIC_0000001811490665__s4544161dae6d4bc4ae45c1ab6e6d9b8e"><h4 class="sectiontitle">ngram_grapsymbol_ignore</h4><p id="EN-US_TOPIC_0000001811490665__a6dd38a96e1814df9ad9e8115d9a18527"><strong id="EN-US_TOPIC_0000001811490665__en-us_topic_0059778487_b1714795426145821">Parameter description</strong>: Specifies whether the ngram parser ignores graphical characters.</p>
<p id="EN-US_TOPIC_0000001811490665__p35111740165317"><strong id="EN-US_TOPIC_0000001811490665__b206451959114917">Type</strong>: USERSET</p>
<p id="EN-US_TOPIC_0000001811490665__a341689c3e4564f40bdc4249d0ba1f55a"><strong id="EN-US_TOPIC_0000001811490665__en-us_topic_0059778487_b44926266164116">Value range</strong>: Boolean</p>
<ul id="EN-US_TOPIC_0000001811490665__u812634179f4246b58fa1ca53ec16fd2b"><li id="EN-US_TOPIC_0000001811490665__le3d1cc04879844a6bd91e8fbd204cbd1"><strong id="EN-US_TOPIC_0000001811490665__a38cf9696df00460091355a9787b85f2d">on</strong>: Ignores graphical characters.</li><li id="EN-US_TOPIC_0000001811490665__l29f7fef9ed694f7b8d696eb515b3548c"><strong id="EN-US_TOPIC_0000001811490665__a6dd38afd340948da948bf1a237d8628c">off</strong>: Does not ignore graphical characters.</li></ul>
<p id="EN-US_TOPIC_0000001811490665__a9978946dd30448b489f7daf914dd2c7b"><strong id="EN-US_TOPIC_0000001811490665__b57149268104838">Default value</strong>: <strong id="EN-US_TOPIC_0000001811490665__b44581368104838">off</strong></p>
</div>
<div class="section" id="EN-US_TOPIC_0000001811490665__s91f97979a62941a6aabcd7be22e87b1b"><h4 class="sectiontitle">ngram_punctuation_ignore</h4><p id="EN-US_TOPIC_0000001811490665__af2219d636f994605965d603f4899e295"><strong id="EN-US_TOPIC_0000001811490665__b25816034104838">Parameter description</strong>: Specifies whether the ngram parser ignores punctuations.</p>
<p id="EN-US_TOPIC_0000001811490665__p15340749135313"><strong id="EN-US_TOPIC_0000001811490665__b13830175924914">Type</strong>: USERSET</p>
<p id="EN-US_TOPIC_0000001811490665__ab431647b3d944d94bb8d71e0fbb495e4"><strong id="EN-US_TOPIC_0000001811490665__en-us_topic_0059778487_b20556540164116">Value range</strong>: Boolean</p>
<ul id="EN-US_TOPIC_0000001811490665__u9da355dcc7e646158ed4863a8754a622"><li id="EN-US_TOPIC_0000001811490665__le3598f8155d8410bb3e4a18075eb5e54"><strong id="EN-US_TOPIC_0000001811490665__en-us_topic_0059778487_b84235270615011">on</strong>: Ignores punctuations.</li><li id="EN-US_TOPIC_0000001811490665__la789482128194478a433ed9418329599"><strong id="EN-US_TOPIC_0000001811490665__a82cf1dbee91f464bb07b7c723ffe2d8c">off</strong>: Does not ignore punctuations.</li></ul>
<p id="EN-US_TOPIC_0000001811490665__a09ada4fa67c5435b9b256d3bc6492356"><strong id="EN-US_TOPIC_0000001811490665__b50347420104838">Default value</strong>: <strong id="EN-US_TOPIC_0000001811490665__en-us_topic_0059778487_b842352706154337">on</strong></p>
</div>
<div class="section" id="EN-US_TOPIC_0000001811490665__scc473fb1be14410e8c9c80a6630b9c9b"><h4 class="sectiontitle">zhparser_multi_duality</h4><p id="EN-US_TOPIC_0000001811490665__a9e820f8ba824420aaa8255b23d9299e7"><strong id="EN-US_TOPIC_0000001811490665__en-us_topic_0085032935_en-us_topic_0059778487_b21126121164652">Parameter description</strong>: Specifies whether Zhparser aggregates segments in long words with duality.</p>
<p id="EN-US_TOPIC_0000001811490665__p18402171519137"><strong id="EN-US_TOPIC_0000001811490665__b63561708502">Type</strong>: USERSET</p>
<p id="EN-US_TOPIC_0000001811490665__en-us_topic_0059778487_p29284164116"><strong id="EN-US_TOPIC_0000001811490665__en-us_topic_0059778487_b263561164116">Value range</strong>: Boolean</p>
<ul id="EN-US_TOPIC_0000001811490665__u2b1e268f44d7497ebcbc2e441009d0e5"><li id="EN-US_TOPIC_0000001811490665__l31c6615f1e6a43df9071c11c1a5f59ea"><strong id="EN-US_TOPIC_0000001811490665__en-us_topic_0059778487_b842352706151932">on</strong>: Aggregates segments in long words with duality.</li><li id="EN-US_TOPIC_0000001811490665__l7e9f5d488e154ee098ffed20ed408dbe"><strong id="EN-US_TOPIC_0000001811490665__b56108910104838">off</strong>: Does not aggregate segments in long words with duality.</li></ul>
<p id="EN-US_TOPIC_0000001811490665__a430967350a3a4e50ad0519932a57fa18"><strong id="EN-US_TOPIC_0000001811490665__b39032958104838">Default value</strong>: <strong id="EN-US_TOPIC_0000001811490665__b15752303104838">off</strong></p>
</div>
<div class="section" id="EN-US_TOPIC_0000001811490665__saef1b85192c54a2ebc7313daa8b29c94"><h4 class="sectiontitle">zhparser_multi_short</h4><p id="EN-US_TOPIC_0000001811490665__a877078cd084d41a1b636eaa95faec23d"><strong id="EN-US_TOPIC_0000001811490665__en-us_topic_0085032935_en-us_topic_0059778487_b6386695617335">Parameter description</strong>: Specifies whether Zhparser executes long words composite divide.</p>
<p id="EN-US_TOPIC_0000001811490665__p632382751313"><strong id="EN-US_TOPIC_0000001811490665__b18550130115010">Type</strong>: USERSET</p>
<p id="EN-US_TOPIC_0000001811490665__abf42e6f3d9c345479a099004f5b8a3fe"><strong id="EN-US_TOPIC_0000001811490665__en-us_topic_0059778487_b30990495164116">Value range</strong>: Boolean</p>
<ul id="EN-US_TOPIC_0000001811490665__ue7eddf4f858d42418f8fa278c3acb1cb"><li id="EN-US_TOPIC_0000001811490665__l0b5824f107734a11a7f4cde72cf24504"><strong id="EN-US_TOPIC_0000001811490665__en-us_topic_0059778487_b842352706152029">on</strong>: Performs compound segmentation for long words.</li><li id="EN-US_TOPIC_0000001811490665__le896cbe381f04f849ee917045d440af6"><strong id="EN-US_TOPIC_0000001811490665__en-us_topic_0059778487_b842352706152046">off</strong>: Does not perform compound segmentation for long words.</li></ul>
<p id="EN-US_TOPIC_0000001811490665__a0d5ef4ebbc2847dab90c9d6f201afbc5"><strong id="EN-US_TOPIC_0000001811490665__b61542225104838">Default value</strong>: <strong id="EN-US_TOPIC_0000001811490665__b17009121104838">on</strong></p>
</div>
<div class="section" id="EN-US_TOPIC_0000001811490665__sa76de64bbeb5480880025c4cec598462"><h4 class="sectiontitle">zhparser_multi_zall</h4><p id="EN-US_TOPIC_0000001811490665__ac3bdd66ba1104367941050a6afd5d424"><strong id="EN-US_TOPIC_0000001811490665__en-us_topic_0085032935_en-us_topic_0059778487_b1346442217511">Parameter description</strong>: Specifies whether Zhparser displays all single words individually.</p>
<p id="EN-US_TOPIC_0000001811490665__p8381113520134"><strong id="EN-US_TOPIC_0000001811490665__b12785190145017">Type</strong>: USERSET</p>
<p id="EN-US_TOPIC_0000001811490665__a64a22988c85740eab5bd4a58d0729429"><strong id="EN-US_TOPIC_0000001811490665__en-us_topic_0059778487_b59741695164116">Value range</strong>: Boolean</p>
<ul id="EN-US_TOPIC_0000001811490665__udb5591317c3940feaae4f924dc46b686"><li id="EN-US_TOPIC_0000001811490665__l84756c28ad1e453f94fd22bfbdf1d72d"><strong id="EN-US_TOPIC_0000001811490665__en-us_topic_0059778487_b842352706152632">on</strong>: Displays all single words separately.</li><li id="EN-US_TOPIC_0000001811490665__lc3e67384536844eaa07f5298d29bbf6f"><strong id="EN-US_TOPIC_0000001811490665__en-us_topic_0059778487_b842352706152718">off</strong>: Does not display all single words separately.</li></ul>
<p id="EN-US_TOPIC_0000001811490665__ab0b45da7db6344c4a2cb7f1c45778e7e"><strong id="EN-US_TOPIC_0000001811490665__b66678085104838">Default value</strong>: <strong id="EN-US_TOPIC_0000001811490665__b63231859104838">off</strong></p>
</div>
<div class="section" id="EN-US_TOPIC_0000001811490665__s54302d6b9cdc464883ab4b438fa0778d"><h4 class="sectiontitle">zhparser_multi_zmain</h4><p id="EN-US_TOPIC_0000001811490665__a377eab3543f84d19abcac1b35e40e44b"><strong id="EN-US_TOPIC_0000001811490665__b23232995104838">Parameter description</strong>: Specifies whether Zhparser displays important single words separately.</p>
<p id="EN-US_TOPIC_0000001811490665__p197784426136"><strong id="EN-US_TOPIC_0000001811490665__b10131212506">Type</strong>: USERSET</p>
<p id="EN-US_TOPIC_0000001811490665__a003cc69d8bcd48ddbea295ae49e383ac"><strong id="EN-US_TOPIC_0000001811490665__en-us_topic_0059778487_b42660784164116">Value range</strong>: Boolean</p>
<ul id="EN-US_TOPIC_0000001811490665__u7073e353fa7a41d882be35029fd1b82e"><li id="EN-US_TOPIC_0000001811490665__lca3d352acf974d109c10589eb6a96c76"><strong id="EN-US_TOPIC_0000001811490665__b52669917104838">on</strong>: Displays important single words separately.</li><li id="EN-US_TOPIC_0000001811490665__l3b54fed1126f452dae86d17806f1e58c"><strong id="EN-US_TOPIC_0000001811490665__b47779347104838">off</strong>: Does not display important single words separately.</li></ul>
<p id="EN-US_TOPIC_0000001811490665__a3c713aacaf134259bba2867191e15279"><strong id="EN-US_TOPIC_0000001811490665__b48144985104838">Default value</strong>: <strong id="EN-US_TOPIC_0000001811490665__b30651685104838">off</strong></p>
</div>
<div class="section" id="EN-US_TOPIC_0000001811490665__sa8182c3c3b9a42e4b0cabfbce51854e8"><h4 class="sectiontitle">zhparser_punctuation_ignore</h4><p id="EN-US_TOPIC_0000001811490665__ab8ae05b508a444b0892e8cc28dcc048c"><strong id="EN-US_TOPIC_0000001811490665__en-us_topic_0085032935_en-us_topic_0059778487_b2661133917518">Parameter description</strong>: Specifies whether the Zhparser segmentation result ignores special characters including punctuations (\r and \n will not be ignored).</p>
<p id="EN-US_TOPIC_0000001811490665__p12899105091316"><strong id="EN-US_TOPIC_0000001811490665__b11205141185018">Type</strong>: USERSET</p>
<p id="EN-US_TOPIC_0000001811490665__a21349b6307a94019b3ead21edb26d28d"><strong id="EN-US_TOPIC_0000001811490665__en-us_topic_0059778487_b40621983164116">Value range</strong>: Boolean</p>
<ul id="EN-US_TOPIC_0000001811490665__u73f7fcf0d4ab486ea71e5311723bd4c8"><li id="EN-US_TOPIC_0000001811490665__lc32cfaee126243dbb5ab4208c9a01ee6"><strong id="EN-US_TOPIC_0000001811490665__en-us_topic_0059778487_b842352706153456">on</strong>: Ignores all the special characters including punctuations.</li><li id="EN-US_TOPIC_0000001811490665__le3ed8bbb11b94720a49ab4e18312e445"><strong id="EN-US_TOPIC_0000001811490665__en-us_topic_0059778487_b84235270615346">off</strong>: Does not ignore all the special characters including punctuations.</li></ul>
<p id="EN-US_TOPIC_0000001811490665__a5fa30af929744c64a6eac16861eaaa32"><strong id="EN-US_TOPIC_0000001811490665__b4365965104838">Default value</strong>: <strong id="EN-US_TOPIC_0000001811490665__b39293686104838">on</strong></p>
</div>
<div class="section" id="EN-US_TOPIC_0000001811490665__sfcf3713397ba4ceebadf55d0f0d55770"><h4 class="sectiontitle">zhparser_seg_with_duality</h4><p id="EN-US_TOPIC_0000001811490665__a325441addef24045abec1427432219cf"><strong id="EN-US_TOPIC_0000001811490665__en-us_topic_0059778487_b56002691165129">Parameter description</strong>: Specifies whether Zhparser aggregates segments in long words with duality.</p>
<p id="EN-US_TOPIC_0000001811490665__p13126127191411"><strong id="EN-US_TOPIC_0000001811490665__b1636861135016">Type</strong>: USERSET</p>
<p id="EN-US_TOPIC_0000001811490665__a152bd89ca3144238b0675cca1fbdcbd0"><strong id="EN-US_TOPIC_0000001811490665__en-us_topic_0059778487_b55537011164116">Value range</strong>: Boolean</p>
<ul id="EN-US_TOPIC_0000001811490665__u813d0d484cbd436391de302d3774c53d"><li id="EN-US_TOPIC_0000001811490665__l87dd2c17a040433786e48814f792920f"><strong id="EN-US_TOPIC_0000001811490665__b842352706153610">on</strong>: Aggregates segments in long words with duality.</li><li id="EN-US_TOPIC_0000001811490665__lac675355e3ea4265b0608b4c8160c780"><strong id="EN-US_TOPIC_0000001811490665__b842352706151932">off</strong>: Does not aggregate segments in long words with duality.</li></ul>
<p id="EN-US_TOPIC_0000001811490665__a496854425d8545198267662ddac16e42"><strong id="EN-US_TOPIC_0000001811490665__b1331619901103619">Default value</strong>: <strong id="EN-US_TOPIC_0000001811490665__b1236838594103619">off</strong></p>
</div>
<div class="section" id="EN-US_TOPIC_0000001811490665__section13787157164412"><a name="EN-US_TOPIC_0000001811490665__section13787157164412"></a><a name="section13787157164412"></a><h4 class="sectiontitle">acceleration_with_compute_pool</h4><p id="EN-US_TOPIC_0000001811490665__p10975810114419"><strong id="EN-US_TOPIC_0000001811490665__b842352706173719">Parameter description</strong>: Specifies whether to use the computing resource pool for acceleration when OBS is queried.</p>
<p id="EN-US_TOPIC_0000001811490665__p314317151418"><strong id="EN-US_TOPIC_0000001811490665__b15559316506">Type</strong>: USERSET</p>
<p id="EN-US_TOPIC_0000001811490665__p199781410174410"><strong id="EN-US_TOPIC_0000001811490665__b29285174104838">Value range</strong>: Boolean</p>
<ul id="EN-US_TOPIC_0000001811490665__ul13981101018449"><li id="EN-US_TOPIC_0000001811490665__li18983010184412"><strong id="EN-US_TOPIC_0000001811490665__b842352706174034">on</strong> indicates that the query covering OBS is accelerated based on the cost when the computing resource pool is available.</li><li id="EN-US_TOPIC_0000001811490665__li09851110114414"><strong id="EN-US_TOPIC_0000001811490665__b842352706174440">off</strong> indicates that no query is accelerated using the computing resource pool.</li></ul>
<p id="EN-US_TOPIC_0000001811490665__p16987310154415"><strong id="EN-US_TOPIC_0000001811490665__b13450398104838">Default value</strong>: <strong id="EN-US_TOPIC_0000001811490665__b53944722104838">off</strong></p>
</div>
<div class="section" id="EN-US_TOPIC_0000001811490665__section6927111511525"><h4 class="sectiontitle">redact_compat_options</h4><p id="EN-US_TOPIC_0000001811490665__p656010248522"><strong id="EN-US_TOPIC_0000001811490665__b129562329502">Parameter description</strong>: Specifies the compatibility option for calculation using masked data. This parameter is supported only by clusters of version 8.1.3.310 or later.</p>
<p id="EN-US_TOPIC_0000001811490665__p656072485210"><strong id="EN-US_TOPIC_0000001811490665__b1632281725">Type</strong>: USERSET</p>
<p id="EN-US_TOPIC_0000001811490665__p125609241526"><strong id="EN-US_TOPIC_0000001811490665__b168308044">Value range</strong>: a string</p>
<ul id="EN-US_TOPIC_0000001811490665__ul171105217102"><li id="EN-US_TOPIC_0000001811490665__li1611552181014"><strong id="EN-US_TOPIC_0000001811490665__b8348132410364">none</strong> indicates that compatibility options are specified.</li><li id="EN-US_TOPIC_0000001811490665__li37529255117"><strong id="EN-US_TOPIC_0000001811490665__b67861419193616">disable_comparison_operator_mask</strong> indicates that comparison operators that do not expose raw data can bypass the data masking check and generate the actual calculation result.</li></ul>
<p id="EN-US_TOPIC_0000001811490665__p8832531111018"><strong id="EN-US_TOPIC_0000001811490665__b1003381844347">Default value</strong>: <strong id="EN-US_TOPIC_0000001811490665__b7993664224347">none</strong></p>
</div>
<div class="section" id="EN-US_TOPIC_0000001811490665__section174079331456"><h4 class="sectiontitle">table_skewness_warning_threshold</h4><p id="EN-US_TOPIC_0000001811490665__p1595016610473"><strong id="EN-US_TOPIC_0000001811490665__b5711028161119">Parameter description</strong>: Specifies the threshold for triggering a table skew alarm.</p>
<p id="EN-US_TOPIC_0000001811490665__p1215324024119"><strong id="EN-US_TOPIC_0000001811490665__b112871636501">Type</strong>: SUSET</p>
<p id="EN-US_TOPIC_0000001811490665__p940773318456"><strong id="EN-US_TOPIC_0000001811490665__b41277322111">Value range</strong>: a floating point number ranging from 0 to 1</p>
<p id="EN-US_TOPIC_0000001811490665__p9407173318455"><strong id="EN-US_TOPIC_0000001811490665__b1567223313119">Default value</strong>: <strong id="EN-US_TOPIC_0000001811490665__b1167318334115">1</strong></p>
</div>
<div class="section" id="EN-US_TOPIC_0000001811490665__section816564619464"><h4 class="sectiontitle">table_skewness_warning_rows</h4><p id="EN-US_TOPIC_0000001811490665__p487310812471"><strong id="EN-US_TOPIC_0000001811490665__b4882101416128">Parameter description</strong>: Specifies the minimum number of rows for triggering a table skew alarm.</p>
<p id="EN-US_TOPIC_0000001811490665__p713494214147"><strong id="EN-US_TOPIC_0000001811490665__b12493113195010">Type</strong>: SUSET</p>
<p id="EN-US_TOPIC_0000001811490665__p81651946184613"><strong id="EN-US_TOPIC_0000001811490665__en-us_topic_0059778564_en-us_topic_0058967768_b54205967">Value range</strong>: an integer ranging from <strong id="EN-US_TOPIC_0000001811490665__b099810385338">0</strong> to <strong id="EN-US_TOPIC_0000001811490665__b91101842193319">INT_MAX</strong></p>
<p id="EN-US_TOPIC_0000001811490665__p1716524624611"><strong id="EN-US_TOPIC_0000001811490665__b918435698">Default value</strong>: <strong id="EN-US_TOPIC_0000001811490665__b46501319151218">100000</strong></p>
</div>
<div class="section" id="EN-US_TOPIC_0000001811490665__section595114015017"><h4 class="sectiontitle">enable_view_update</h4><p id="EN-US_TOPIC_0000001811490665__p1096134015012"><strong id="EN-US_TOPIC_0000001811490665__b188201841105110">Parameter description</strong>: Enables the view update function or not.</p>
<p id="EN-US_TOPIC_0000001811490665__p6961140125018"><strong id="EN-US_TOPIC_0000001811490665__b6153754135116">Type</strong>: POSTMASTER</p>
<p id="EN-US_TOPIC_0000001811490665__p129614403502"><strong id="EN-US_TOPIC_0000001811490665__b1152256205116">Value range</strong>: Boolean</p>
<ul id="EN-US_TOPIC_0000001811490665__ul5961540105011"><li id="EN-US_TOPIC_0000001811490665__li1496840145010"><strong id="EN-US_TOPIC_0000001811490665__b2484175916511">on</strong> indicates that the view update function is enabled.</li><li id="EN-US_TOPIC_0000001811490665__li6961940195011"><strong id="EN-US_TOPIC_0000001811490665__b1333214115213">off</strong> indicates that the view update function is disabled.</li></ul>
<p id="EN-US_TOPIC_0000001811490665__p11962040125013"><strong id="EN-US_TOPIC_0000001811490665__b12704172016572">Default value</strong>: <strong id="EN-US_TOPIC_0000001811490665__b11704102013576">off</strong></p>
</div>
<div class="section" id="EN-US_TOPIC_0000001811490665__section8167104693414"><h4 class="sectiontitle">view_independent</h4><p id="EN-US_TOPIC_0000001811490665__p13167546103414"><strong id="EN-US_TOPIC_0000001811490665__b1991181685217">Parameter description</strong>: Decouples views from tables, functions, and synonyms or not. After the base table is restored, automatic association and re-creation are supported.</p>
<p id="EN-US_TOPIC_0000001811490665__p916754614346"><strong id="EN-US_TOPIC_0000001811490665__b1415213323525">Type</strong>: SIGHUP</p>
<p id="EN-US_TOPIC_0000001811490665__p18167194619343"><strong id="EN-US_TOPIC_0000001811490665__b8336153311528">Value range</strong>: Boolean</p>
<ul id="EN-US_TOPIC_0000001811490665__ul161671446163410"><li id="EN-US_TOPIC_0000001811490665__li20167946173411"><strong id="EN-US_TOPIC_0000001811490665__b5389637155219">on</strong> indicates that the view decoupling function is enabled. Tables, functions, synonyms, and other views on which views depend can be deleted separately (except temporary tables and temporary views). Associated views are reserved but unavailable.</li><li id="EN-US_TOPIC_0000001811490665__li616764619344"><strong id="EN-US_TOPIC_0000001811490665__b52255412527">off</strong> indicates that the view decoupling function is disabled. Tables, functions, synonyms, and other views on which views depend cannot be deleted separately. You can only delete them in the cascade mode.</li></ul>
<p id="EN-US_TOPIC_0000001811490665__p816774616341"><strong id="EN-US_TOPIC_0000001811490665__b12307102555711">Default value</strong>: <strong id="EN-US_TOPIC_0000001811490665__b5307525125714">off</strong></p>
</div>
<div class="section" id="EN-US_TOPIC_0000001811490665__section7911451155615"><h4 class="sectiontitle">assign_abort_xid</h4><p id="EN-US_TOPIC_0000001811490665__p18424204185714"><strong id="EN-US_TOPIC_0000001811490665__b11465101904310">Parameter description</strong>: Determines the transaction to be aborted based on the specified XID in a query.</p>
<p id="EN-US_TOPIC_0000001811490665__p17424646573"><strong id="EN-US_TOPIC_0000001811490665__b1862173464319">Type</strong>: USERSET</p>
<p id="EN-US_TOPIC_0000001811490665__p1742414413577"><strong id="EN-US_TOPIC_0000001811490665__b102026494473">Value range</strong>: a character string with the specified XID</p>
<div class="caution" id="EN-US_TOPIC_0000001811490665__note85011588571"><span class="cautiontitle"><img src="public_sys-resources/caution_3.0-en-us.png"> </span><div class="cautionbody"><p id="EN-US_TOPIC_0000001811490665__p1650258205716">This parameter is used only for quick restoration if a user deletes data by mistake (DELETE operation). Do not use this parameter in other scenarios. Otherwise, visible transaction errors may occur.</p>
</div></div>
</div>
<div class="section" id="EN-US_TOPIC_0000001811490665__section196600274573"><h4 class="sectiontitle">default_distribution_mode</h4><p id="EN-US_TOPIC_0000001811490665__p323264318579"><strong id="EN-US_TOPIC_0000001811490665__b8391327103813">Parameter description</strong>: Specifies the default distribution mode of a table. This feature is supported only in 8.1.2 or later.</p>
<p id="EN-US_TOPIC_0000001811490665__p16552323135815"><strong id="EN-US_TOPIC_0000001811490665__b17194144317389">Type</strong>: USERSET</p>
<div class="p" id="EN-US_TOPIC_0000001811490665__p11138202811583"><strong id="EN-US_TOPIC_0000001811490665__b1572684923810">Value range</strong>: enumerated values<ul id="EN-US_TOPIC_0000001811490665__ul5611281415"><li id="EN-US_TOPIC_0000001811490665__li4621128714"><strong id="EN-US_TOPIC_0000001811490665__b1167273915438">roundrobin</strong>: If the distribution mode is not specified during table creation, the default distribution mode is selected according to the following rules:<ol id="EN-US_TOPIC_0000001811490665__ol137381934837"><li id="EN-US_TOPIC_0000001811490665__li87381341531">If the primary key or unique constraint is included during table creation, hash distribution is selected. The distribution column is the column corresponding to the primary key or unique constraint.</li><li id="EN-US_TOPIC_0000001811490665__li0741558414">If the primary key or unique constraint is not included during table creation, round-robin distribution is selected.</li></ol>
</li><li id="EN-US_TOPIC_0000001811490665__li1130420261250"><strong id="EN-US_TOPIC_0000001811490665__b1717173534217">hash</strong>: If the distribution mode is not specified during table creation, the default distribution mode is selected according to the following rules:<ol id="EN-US_TOPIC_0000001811490665__ol4873444050"><li id="EN-US_TOPIC_0000001811490665__li38741447517">If the primary key or unique constraint is included during table creation, hash distribution is selected. The distribution column is the column corresponding to the primary key or unique constraint.</li><li id="EN-US_TOPIC_0000001811490665__li990712591559">If the primary key or unique constraint is not included during table creation but there are columns whose data types can be used as distribution columns, hash distribution is selected. The distribution column is the first column whose data type can be used as a distribution column.</li><li id="EN-US_TOPIC_0000001811490665__li462574677">If the primary key or unique constraint is not included during table creation and no column whose data type can be used as a distribution column exists, round-robin distribution is selected.</li></ol>
</li></ul>
</div>
<p id="EN-US_TOPIC_0000001811490665__p182017910593"><strong id="EN-US_TOPIC_0000001811490665__b13341161013393">Default value</strong>: <strong id="EN-US_TOPIC_0000001811490665__b134814108399">roundrobin</strong></p>
<div class="note" id="EN-US_TOPIC_0000001811490665__note4275125192119"><img src="public_sys-resources/note_3.0-en-us.png"><span class="notetitle"> </span><div class="notebody"><p id="EN-US_TOPIC_0000001811490665__p1627513510219">The default value of this parameter is <strong id="EN-US_TOPIC_0000001811490665__b224073692">roundrobin</strong> for a new GaussDB(DWS) 8.1.2 cluster and is <strong id="EN-US_TOPIC_0000001811490665__b2816122717106">hash</strong> for an upgrade to GaussDB(DWS) 8.1.2.</p>
</div></div>
</div>
<div class="section" id="EN-US_TOPIC_0000001811490665__section1311314111336"><h4 class="sectiontitle">object_mtime_record_mode</h4><p id="EN-US_TOPIC_0000001811490665__p94712443315"><strong id="EN-US_TOPIC_0000001811490665__b18668162819508">Parameter description</strong>: Sets the update action of the <strong id="EN-US_TOPIC_0000001811490665__b1487751655118">mtime</strong> column in the <strong id="EN-US_TOPIC_0000001811490665__b11124102685111">PG_OBJECT</strong> system catalog.</p>
<p id="EN-US_TOPIC_0000001811490665__p567111347337"><strong id="EN-US_TOPIC_0000001811490665__b11761151725016">Type</strong>: SIGHUP</p>
<p id="EN-US_TOPIC_0000001811490665__p16111836183315"><strong id="EN-US_TOPIC_0000001811490665__b8809029145110">Value range</strong>: a string</p>
<ul id="EN-US_TOPIC_0000001811490665__ul7676612103419"><li id="EN-US_TOPIC_0000001811490665__li467631233413">de<strong id="EN-US_TOPIC_0000001811490665__b137791040165112">fault</strong>: <strong id="EN-US_TOPIC_0000001811490665__b2521158185216">ALTER</strong>, <strong id="EN-US_TOPIC_0000001811490665__b1088920112521">COMMENT</strong>, <strong id="EN-US_TOPIC_0000001811490665__b03601517145212">GRANT/REVOKE</strong>, and <strong id="EN-US_TOPIC_0000001811490665__b9859132075217">TRUNCATE</strong> operations update the <strong id="EN-US_TOPIC_0000001811490665__b865922918525">mtime</strong> column by default.</li><li id="EN-US_TOPIC_0000001811490665__li126761912153413"><strong id="EN-US_TOPIC_0000001811490665__b119711621125210">disable</strong>: The <strong id="EN-US_TOPIC_0000001811490665__b397122165216">mtime</strong> column is not updated.</li><li id="EN-US_TOPIC_0000001811490665__li1667611215347"><strong id="EN-US_TOPIC_0000001811490665__b2056231735315">disable_acl</strong>: <strong id="EN-US_TOPIC_0000001811490665__b1520683313532">GRANT</strong> or <strong id="EN-US_TOPIC_0000001811490665__b851563795314">REVOKE</strong> operation does not update the <strong id="EN-US_TOPIC_0000001811490665__b6822145565311">mtime</strong> column.</li><li id="EN-US_TOPIC_0000001811490665__li196761012103413"><strong id="EN-US_TOPIC_0000001811490665__b6915192615543">disable_truncate</strong>: <strong id="EN-US_TOPIC_0000001811490665__b1355984816543">TRUNCATE</strong> operations do not update the <strong id="EN-US_TOPIC_0000001811490665__b19136547548">mtime</strong> column.</li><li id="EN-US_TOPIC_0000001811490665__li15676111203416"><strong id="EN-US_TOPIC_0000001811490665__b256733185515">disable_partition</strong>: Partition <strong id="EN-US_TOPIC_0000001811490665__b2043511115510">ALTER</strong> operations do not update the <strong id="EN-US_TOPIC_0000001811490665__b74355112557">mtime</strong> column.</li></ul>
<p id="EN-US_TOPIC_0000001811490665__p1111314111331"><strong id="EN-US_TOPIC_0000001811490665__b318161545617">Default value</strong>: <strong id="EN-US_TOPIC_0000001811490665__b618201535613">default</strong></p>
</div>
<div class="section" id="EN-US_TOPIC_0000001811490665__section14763913254"><h4 class="sectiontitle">max_volatile_tables</h4><p id="EN-US_TOPIC_0000001811490665__p1576315116250"><strong id="EN-US_TOPIC_0000001811490665__b14752104275716">Parameter description</strong>: Specifies the maximum number of volatile tables created for each session, including volatile tables and their auxiliary tables. This parameter is supported by clusters of version 8.2.0 or later.</p>
<p id="EN-US_TOPIC_0000001811490665__p137637172520"><strong id="EN-US_TOPIC_0000001811490665__b742353739">Type</strong>: USERSET</p>
<p id="EN-US_TOPIC_0000001811490665__p1076320102511"><strong id="EN-US_TOPIC_0000001811490665__b176311122512">Value range</strong>: an integer ranging from 0 to INT_MAX</p>
<p id="EN-US_TOPIC_0000001811490665__p167634172518"><strong id="EN-US_TOPIC_0000001811490665__b5852182074347">Default value</strong>: <strong id="EN-US_TOPIC_0000001811490665__b15840178004347">300</strong></p>
</div>
<div class="section" id="EN-US_TOPIC_0000001811490665__section41349523516"><h4 class="sectiontitle">query_cache_refresh_time</h4><p id="EN-US_TOPIC_0000001811490665__p14135652650"><strong id="EN-US_TOPIC_0000001811490665__b18351205412417">Parameter description</strong>: Specifies the cache refresh interval for queries for which the <strong id="EN-US_TOPIC_0000001811490665__b43525549242">enable_accelerate_select</strong> parameter takes effect. This parameter is supported only by clusters of version 8.3.0 or later.</p>
<p id="EN-US_TOPIC_0000001811490665__p141358521453"><strong id="EN-US_TOPIC_0000001811490665__b2058532553">Type</strong>: USERSET</p>
<p id="EN-US_TOPIC_0000001811490665__p9135252154"><strong id="EN-US_TOPIC_0000001811490665__b913525220513">Value range</strong>: a floating point number ranging from 0 to 10000.0, in seconds</p>
<p id="EN-US_TOPIC_0000001811490665__p131353521955"><strong id="EN-US_TOPIC_0000001811490665__b169021111182612">Default value</strong>: <strong id="EN-US_TOPIC_0000001811490665__b483591532612">60.0</strong></p>
</div>
<div class="section" id="EN-US_TOPIC_0000001811490665__section2657418103710"><h4 class="sectiontitle">vector_engine_strategy</h4><p id="EN-US_TOPIC_0000001811490665__p86511018133715"><strong id="EN-US_TOPIC_0000001811490665__b1459344018612">Parameter description</strong>: Specifies the vectorization enhancement policy. This parameter is supported only by clusters of version 8.3.0 or later.</p>
<p id="EN-US_TOPIC_0000001811490665__p865119183374"><strong id="EN-US_TOPIC_0000001811490665__b232565248">Type</strong>: USERSET</p>
<p id="EN-US_TOPIC_0000001811490665__p4652818163716"><strong id="EN-US_TOPIC_0000001811490665__b106515182371">Value range</strong>: enumerated values</p>
<ul id="EN-US_TOPIC_0000001811490665__ul166521018113711"><li id="EN-US_TOPIC_0000001811490665__li186527187376"><strong id="EN-US_TOPIC_0000001811490665__b41071625576">force</strong> specifies that the vectorization-enhanced plan is forcibly rolled back to the row storage plan when there are scenarios that do not support vectorization.</li><li id="EN-US_TOPIC_0000001811490665__li156523184375"><strong id="EN-US_TOPIC_0000001811490665__b155867496812">improve</strong> specifies that vectorization enhancement is enabled even when there are scenarios that do not support vectorization.</li></ul>
<p id="EN-US_TOPIC_0000001811490665__p16652121810373"><strong id="EN-US_TOPIC_0000001811490665__b4537419151115">Default value</strong>: <strong id="EN-US_TOPIC_0000001811490665__b16429153519168">improve</strong></p>
</div>
<div class="section" id="EN-US_TOPIC_0000001811490665__section1140172274012"><h4 class="sectiontitle">default_temptable_type</h4><p id="EN-US_TOPIC_0000001811490665__p1040162244020"><strong id="EN-US_TOPIC_0000001811490665__b1630802492619">Parameter description</strong>: Specifies the type of temporary table created when <strong id="EN-US_TOPIC_0000001811490665__b12610145317260">CREATE TABLE</strong> is used to create a temporary table without specifying the table type before <strong id="EN-US_TOPIC_0000001811490665__b87781513279">TEMP</strong> or <strong id="EN-US_TOPIC_0000001811490665__b1458163162711">TEMPORARY</strong>. This parameter is supported only by clusters of version 9.1.0 or later.</p>
<p id="EN-US_TOPIC_0000001811490665__p4402722134010"><strong id="EN-US_TOPIC_0000001811490665__b1052653237">Type</strong>: USERSET</p>
<p id="EN-US_TOPIC_0000001811490665__p174021221405"><strong id="EN-US_TOPIC_0000001811490665__b1779963886">Value range</strong>: enumerated values</p>
<ul id="EN-US_TOPIC_0000001811490665__ul17402922164011"><li id="EN-US_TOPIC_0000001811490665__li164021322194012"><strong id="EN-US_TOPIC_0000001811490665__b1176022112713">local</strong>: creates a local temporary table when the type is not specified.</li><li id="EN-US_TOPIC_0000001811490665__li1440262220402"><strong id="EN-US_TOPIC_0000001811490665__b1969179142813">volatile</strong>: creates a volatile temporary table when the type is not specified.</li></ul>
<p id="EN-US_TOPIC_0000001811490665__p1740272254018"><strong id="EN-US_TOPIC_0000001811490665__b15293642112813">Default value</strong>: <strong id="EN-US_TOPIC_0000001811490665__b16402152218404">local</strong></p>
</div>
<div class="section" id="EN-US_TOPIC_0000001811490665__section13636075591"><h4 class="sectiontitle">pgxc_node_readonly</h4><p id="EN-US_TOPIC_0000001811490665__p1263616725916"><strong id="EN-US_TOPIC_0000001811490665__b1663611795912">Parameter description</strong>: Specifies whether a CN or DN is an elastic or classic DN. This parameter is supported only by clusters of version 9.1.0 or later.</p>
<p id="EN-US_TOPIC_0000001811490665__p363611717598"><strong id="EN-US_TOPIC_0000001811490665__b6179902">Type</strong>: SUSET</p>
<p id="EN-US_TOPIC_0000001811490665__p196367735918"><strong id="EN-US_TOPIC_0000001811490665__b1015949386">Value range</strong>: Boolean</p>
<ul id="EN-US_TOPIC_0000001811490665__ul10345111013310"><li id="EN-US_TOPIC_0000001811490665__li1234521010310"><strong id="EN-US_TOPIC_0000001811490665__b13199154453012">on</strong> indicates that the CN or DN is an elastic node.</li><li id="EN-US_TOPIC_0000001811490665__li93457101737"><strong id="EN-US_TOPIC_0000001811490665__b23964783118">off</strong> indicates that the CN or DN is a classic node.</li></ul>
<p id="EN-US_TOPIC_0000001811490665__p86361735911"><strong id="EN-US_TOPIC_0000001811490665__b1374286996">Default value</strong>: <strong id="EN-US_TOPIC_0000001811490665__b1367365877">off</strong></p>
</div>
<div class="section" id="EN-US_TOPIC_0000001811490665__section12702211104518"><h4 class="sectiontitle">hudi_sync_max_commits</h4><p id="EN-US_TOPIC_0000001811490665__p67021111452"><strong id="EN-US_TOPIC_0000001811490665__b13298522327">Parameter description</strong>: Specifies the maximum number of commits for a single synchronization task in Hudi. This parameter is supported only by clusters of version 9.1.0.100 or later.</p>
<p id="EN-US_TOPIC_0000001811490665__p97021511134513"><strong id="EN-US_TOPIC_0000001811490665__b750592740">Type</strong>: SIGHUP</p>
<p id="EN-US_TOPIC_0000001811490665__p14702201174517"><strong id="EN-US_TOPIC_0000001811490665__b1070218114457">Value range</strong>: an integer ranging from –1 to INT_MAX</p>
<ul id="EN-US_TOPIC_0000001811490665__ul91181552115516"><li id="EN-US_TOPIC_0000001811490665__li131183527557"><strong id="EN-US_TOPIC_0000001811490665__b2115174293318">–1</strong> indicates no limit.</li><li id="EN-US_TOPIC_0000001811490665__li91196526553"><strong id="EN-US_TOPIC_0000001811490665__b1048525919337">0</strong> indicates no limit.</li><li id="EN-US_TOPIC_0000001811490665__li1711905216558">Any other value indicates the maximum number of commits.</li></ul>
<p id="EN-US_TOPIC_0000001811490665__p1170213118452"><strong id="EN-US_TOPIC_0000001811490665__b1421016193418">Default value</strong>: <strong id="EN-US_TOPIC_0000001811490665__b1142171616349">–1</strong></p>
<p id="EN-US_TOPIC_0000001811490665__p53319531244"></p>
</div>
<div class="section" id="EN-US_TOPIC_0000001811490665__section856817100586"><h4 class="sectiontitle">foreign_table_default_rw_options</h4><p id="EN-US_TOPIC_0000001811490665__p5568910135818"><strong id="EN-US_TOPIC_0000001811490665__b11711115153716">Parameter description</strong>: Specifies the default permissions when creating a foreign table without specifying them. This parameter is supported only by clusters of version 9.0.3 or later.</p>
<p id="EN-US_TOPIC_0000001811490665__p456831014588"><strong id="EN-US_TOPIC_0000001811490665__b1432049494">Type</strong>: USERSET</p>
<p id="EN-US_TOPIC_0000001811490665__p55686108587"><strong id="EN-US_TOPIC_0000001811490665__b1205183486">Value range</strong>: a string</p>
<ul id="EN-US_TOPIC_0000001811490665__ul850415225510"><li id="EN-US_TOPIC_0000001811490665__li1504115285513"><strong id="EN-US_TOPIC_0000001811490665__b32551420123818">READ_ONLY</strong> indicates the read-only permission.</li><li id="EN-US_TOPIC_0000001811490665__li145041652115515"><strong id="EN-US_TOPIC_0000001811490665__b3234163113388">WRITE_ONLY</strong> indicates the write-only permission.</li><li id="EN-US_TOPIC_0000001811490665__li13504852195517"><strong id="EN-US_TOPIC_0000001811490665__b1574613395386">READ_WRITE</strong> indicates the read-write permission.</li></ul>
<p id="EN-US_TOPIC_0000001811490665__p1956821016588"><strong id="EN-US_TOPIC_0000001811490665__b985211186350">Default value</strong>: <strong id="EN-US_TOPIC_0000001811490665__b756891075818">READ_ONLY</strong></p>
</div>
</div>
<div>
<div class="familylinks">
<div class="parentlink"><strong>Parent topic:</strong> <a href="dws_04_0883.html">GUC Parameters of the GaussDB(DWS) Database</a></div>
</div>
</div>