You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hawq.apache.org by hu...@apache.org on 2016/05/04 03:10:55 UTC

incubator-hawq git commit: HAWQ-712. Add GUC gp_vmem_idle_resource_timeout back to do timeout for gang release in idle session

Repository: incubator-hawq
Updated Branches:
  refs/heads/master b357dbcd9 -> 1363d3ef2


HAWQ-712. Add GUC gp_vmem_idle_resource_timeout back to do timeout for gang release in idle session


Project: http://git-wip-us.apache.org/repos/asf/incubator-hawq/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-hawq/commit/1363d3ef
Tree: http://git-wip-us.apache.org/repos/asf/incubator-hawq/tree/1363d3ef
Diff: http://git-wip-us.apache.org/repos/asf/incubator-hawq/diff/1363d3ef

Branch: refs/heads/master
Commit: 1363d3ef2cbd18d6e50366dd536b57da029862ed
Parents: b357dbc
Author: Ruilong Huo <rh...@pivotal.io>
Authored: Mon May 2 20:34:19 2016 -0700
Committer: Ruilong Huo <rh...@pivotal.io>
Committed: Mon May 2 20:34:19 2016 -0700

----------------------------------------------------------------------
 src/backend/utils/misc/guc.c                  | 14 ++++++++++++++
 src/backend/utils/misc/postgresql.conf.sample |  1 +
 2 files changed, 15 insertions(+)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/1363d3ef/src/backend/utils/misc/guc.c
----------------------------------------------------------------------
diff --git a/src/backend/utils/misc/guc.c b/src/backend/utils/misc/guc.c
index 8e047a2..4c9fdb1 100644
--- a/src/backend/utils/misc/guc.c
+++ b/src/backend/utils/misc/guc.c
@@ -5046,6 +5046,20 @@ static struct config_int ConfigureNamesInt[] =
 	},
 
 	{
+		{"gp_vmem_idle_resource_timeout", PGC_USERSET, CLIENT_CONN_OTHER,
+			gettext_noop("Sets the time a session can be idle (in milliseconds) before we release gangs on the segment DBs to free resources."),
+			gettext_noop("A value of 0 turns off the timeout."),
+			GUC_UNIT_MS | GUC_GPDB_ADDOPT
+		},
+		&IdleSessionGangTimeout,
+#ifdef USE_ASSERT_CHECKING
+		600000, 0, INT_MAX, NULL, NULL /* 10 minutes by default on debug builds.*/
+#else
+		18000, 0, INT_MAX, NULL, NULL
+#endif
+	},
+
+	{
 		{"vacuum_freeze_min_age", PGC_USERSET, CLIENT_CONN_STATEMENT,
 			gettext_noop("Minimum age at which VACUUM should freeze a table row."),
 			NULL

http://git-wip-us.apache.org/repos/asf/incubator-hawq/blob/1363d3ef/src/backend/utils/misc/postgresql.conf.sample
----------------------------------------------------------------------
diff --git a/src/backend/utils/misc/postgresql.conf.sample b/src/backend/utils/misc/postgresql.conf.sample
index c88addd..0d4ca06 100755
--- a/src/backend/utils/misc/postgresql.conf.sample
+++ b/src/backend/utils/misc/postgresql.conf.sample
@@ -482,6 +482,7 @@ gp_segment_connect_timeout = 600s
 
 # - Resource limits -
 hawq_re_memory_overcommit_max = 8192  # Maximum quota of memory overcommit (in MB) per HAWQ physical segment in resource enforcement
+#gp_vmem_idle_resource_timeout = 18000 # idle-time before gang-release, in milliseconds (zero disables release).
 
 #------------------------------------------------------------------------------
 # CUSTOMIZED OPTIONS