You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hawq.apache.org by yo...@apache.org on 2016/09/14 16:30:38 UTC
[3/6] incubator-hawq-docs git commit: add new guc
gp_vmem_idle_resource_timeout
add new guc gp_vmem_idle_resource_timeout
Project: http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/commit/1212af9a
Tree: http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/tree/1212af9a
Diff: http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/diff/1212af9a
Branch: refs/heads/develop
Commit: 1212af9a0e228cf5c9f8dfee2128cbadee613487
Parents: 2a0b4a9
Author: Lisa Owen <lo...@pivotal.io>
Authored: Tue Sep 13 16:55:35 2016 -0700
Committer: Lisa Owen <lo...@pivotal.io>
Committed: Tue Sep 13 16:55:35 2016 -0700
----------------------------------------------------------------------
reference/guc/guc_category-list.html.md.erb | 1 +
reference/guc/parameter_definitions.html.md.erb | 11 +++++++++++
2 files changed, 12 insertions(+)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/blob/1212af9a/reference/guc/guc_category-list.html.md.erb
----------------------------------------------------------------------
diff --git a/reference/guc/guc_category-list.html.md.erb b/reference/guc/guc_category-list.html.md.erb
index dcf31ad..715583b 100644
--- a/reference/guc/guc_category-list.html.md.erb
+++ b/reference/guc/guc_category-list.html.md.erb
@@ -170,6 +170,7 @@ The parameters in this topic control the configuration of the HAWQ array and its
- [gp\_enable\_direct\_dispatch](parameter_definitions.html#gp_enable_direct_dispatch)
- [gp\_segment\_connect\_timeout](parameter_definitions.html#gp_segment_connect_timeout)
- [gp\_set\_proc\_affinity](parameter_definitions.html#gp_set_proc_affinity)
+- [gp\_vmem\_idle\_resource\_timeout](parameter_definitions.html#gp_vmem_idle_resource_timeout)
### <a id="topic52"></a>Fault Operation Parameters
http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/blob/1212af9a/reference/guc/parameter_definitions.html.md.erb
----------------------------------------------------------------------
diff --git a/reference/guc/parameter_definitions.html.md.erb b/reference/guc/parameter_definitions.html.md.erb
index 3b2157a..af87b75 100644
--- a/reference/guc/parameter_definitions.html.md.erb
+++ b/reference/guc/parameter_definitions.html.md.erb
@@ -218,6 +218,8 @@ Descriptions of the HAWQ server configuration parameters listed alphabetically.
- **[gp\_statistics\_use\_fkeys](../../reference/guc/parameter_definitions.html#gp_statistics_use_fkeys)**
+- **[gp\_vmem\_idle\_resource\_timeout](../../reference/guc/parameter_definitions.html#gp_vmem_idle_resource_timeout)**
+
- **[gp\_vmem\_protect\_segworker\_cache\_limit](../../reference/guc/parameter_definitions.html#gp_vmem_protect_segworker_cache_limit)**
- **[gp\_workfile\_checksumming](../../reference/guc/parameter_definitions.html#gp_workfile_checksumming)**
@@ -1659,6 +1661,15 @@ When enabled, allows the legacy query optimizer (planner) to use foreign key inf
|-------------|---------|-------------------------|
| Boolean | on | master, session, reload |
+## <a name="gp_vmem_idle_resource_timeout"></a>gp\_vmem\_idle\_resource\_timeout
+
+Sets the time in milliseconds a session can be idle before gangs on the segment databases are released to free up resources.
+
+| Value Range | Default | Set Classifications |
+|----------------|---------|-------------------------|
+| number of milliseconds | 18000 | master, session, reload |
+
+
## <a name="gp_vmem_protect_segworker_cache_limit"></a>gp\_vmem\_protect\_segworker\_cache\_limit
If a query executor process consumes more than this configured amount, then the process will not be cached for use in subsequent queries after the process completes. Systems with lots of connections or idle processes may want to reduce this number to free more memory on the segments. Note that this is a local parameter and must be set for every segment.