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/master Commit: 1212af9a0e228cf5c9f8dfee2128cbadee613487 Parents: 2a0b4a9 Author: Lisa Owen <[email protected]> Authored: Tue Sep 13 16:55:35 2016 -0700 Committer: Lisa Owen <[email protected]> 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.
