[ https://issues.apache.org/jira/browse/HAWQ-1382?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15925307#comment-15925307 ]
ASF GitHub Bot commented on HAWQ-1382: -------------------------------------- Github user dyozie commented on a diff in the pull request: https://github.com/apache/incubator-hawq-docs/pull/103#discussion_r106058017 --- Diff: markdown/resourcemgmt/ConfigureResourceManagement.html.md.erb --- @@ -100,22 +100,25 @@ In some cases, you may want to specify additional resource quotas on the query s The following configuration properties allow a user to control resource quotas without altering corresponding resource queues. -- [hawq\_rm\_stmt\_vseg\_memory](../reference/guc/parameter_definitions.html) - [hawq\_rm\_stmt\_nvseg](../reference/guc/parameter_definitions.html) +- [hawq\_rm\_stmt\_vseg\_memory](../reference/guc/parameter_definitions.html) However, the changed resource quota for the virtual segment cannot exceed the resource queue’s maximum capacity in HAWQ. +***Note:*** The value of `hawq_rm_stmt_vseg_memory` depends on `hawq_rm_stmt_nvseg`, which defines the number of virtual segments used for the query. You must set `hawq_rm_stmt_nvseg` to a value greater than 0 before setting the memory quota for each segment with `hawq_rm_stmt_vseg_memory`. After running a query or completing the session, the value of `hawq_rm_stmt_nvseg` should be reset to 0 to disable the statement level resource quota. --- End diff -- Change "the value of `hawq_rm_stmt_nvseg` should be reset to 0 " to "reset the value of `hawq_rm_stmt_nvseg` to 0" > Specify necessary setup for hawq_rm_stmt_nvseg and hawq_rm_stmt_vseg_memory > ---------------------------------------------------------------------------- > > Key: HAWQ-1382 > URL: https://issues.apache.org/jira/browse/HAWQ-1382 > Project: Apache HAWQ > Issue Type: Improvement > Components: Documentation > Reporter: Jane Beckman > Assignee: David Yozie > Fix For: 2.2.0.0-incubating, 2.1.0.0-incubating > > > You must set hawq_rm_stmt_nvseg before setting hawq_rm_stmt_vseg_memory > To enable statement level, users must set hawq_rm_stmt_nvseg to a number > larger than 0, run desired query, then set it back. -- This message was sent by Atlassian JIRA (v6.3.15#6346)