hawq-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From yo...@apache.org
Subject [3/6] incubator-hawq-docs git commit: add new guc gp_vmem_idle_resource_timeout
Date Wed, 14 Sep 2016 16:30:38 GMT
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 <lowen@pivotal.io>
Authored: Tue Sep 13 16:55:35 2016 -0700
Committer: Lisa Owen <lowen@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.


Mime
View raw message