codekingpro/portable-devtools
114k
1
2
3<!DOCTYPE html>
4
5<html lang="en" data-content_root="./">
6 <head>
7 <meta charset="utf-8" />
8 <meta name="viewport" content="width=device-width, initial-scale=1.0" /><meta name="viewport" content="width=device-width, initial-scale=1" />
9
10 <title>Resource Group Dialog — pgAdmin 4 8.6 documentation</title>
11 <link rel="stylesheet" type="text/css" href="_static/pygments.css?v=fa44fd50" />
12 <link rel="stylesheet" type="text/css" href="_static/style.css?v=d36593c3" />
13
14 <script src="_static/documentation_options.js?v=d4c83366"></script>
15 <script src="_static/doctools.js?v=9a2dae69"></script>
16 <script src="_static/sphinx_highlight.js?v=dc90522c"></script>
17
18 <script src="_static/sidebar.js"></script>
19
20 <link rel="index" title="Index" href="genindex.html" />
21 <link rel="search" title="Search" href="search.html" />
22 <link rel="next" title="Login/Group Role Dialog" href="role_dialog.html" />
23 <link rel="prev" title="Database Dialog" href="database_dialog.html" />
24 </head><body>
25 <div class="related" role="navigation" aria-label="related navigation">
26 <h3>Navigation</h3>
27 <ul>
28 <li class="right" style="margin-right: 10px">
29 <a href="genindex.html" title="General Index"
30 accesskey="I">index</a></li>
31 <li class="right" >
32 <a href="role_dialog.html" title="Login/Group Role Dialog"
33 accesskey="N">next</a> |</li>
34 <li class="right" >
35 <a href="database_dialog.html" title="Database Dialog"
36 accesskey="P">previous</a> |</li>
37 <li class="nav-item nav-item-0"><a href="index.html">pgAdmin 4 8.6 documentation</a> »</li>
38 <li class="nav-item nav-item-1"><a href="managing_cluster_objects.html" accesskey="U">Managing Cluster Objects</a> »</li>
39 <li class="nav-item nav-item-this"><a href="">Resource Group Dialog</a></li>
40 </ul>
41 </div>
42
43 <div class="document">
44 <div class="documentwrapper">
45 <div class="bodywrapper">
46 <div class="body" role="main">
47
48 <section id="resource-group-dialog">
49<span id="id1"></span><h1><span class="target" id="index-0"></span>Resource Group Dialog<a class="headerlink" href="#resource-group-dialog" title="Link to this heading">¶</a></h1>
50<p>Use the <em>Resource Group</em> dialog to create a resource group and set values for
51its resources. A resource group is a named, global group on which various
52resource usage limits can be defined. The resource group is accessible from all
53databases in the cluster. To use the <em>Resource Group</em> dialog, you must have
54superuser privileges. Please note that resource groups are supported when
55connected to EDB Postgres Advanced Server; for more information about using
56resource groups, please see the EDB Postgres Advanced Server Guide, available
57at:</p>
58<blockquote>
59<div><p><a class="reference external" href="http://www.enterprisedb.com/">http://www.enterprisedb.com/</a></p>
60</div></blockquote>
61<p>Fields used to create a resource group are located on the <em>General</em> tab. The
62<em>SQL</em> tab displays the SQL code generated by your selections on the <em>Resource
63Group</em> dialog.</p>
64<img alt="Resource Group dialog general tab" class="align-center" src="_images/resource_group_general.png" />
65<p>Use the fields on the <em>General</em> tab to specify resource group attributes:</p>
66<ul class="simple">
67<li><p>Use the <em>Name</em> field to add a descriptive name for the resource group. This
68name will be displayed in the tree control.</p></li>
69<li><p>Use the <em>CPU rate limit (%)</em> field to set the value of the CPU rate limit
70resource type assigned to the resource group. The valid range for a CPU rate
71limit is from 0 to 1.67772e+07. The default value is 0.</p></li>
72<li><p>Use the <em>Dirty rate limit (KB)</em> field to set the value of the dirty rate
73limit resource type assigned to the resource group. The valid range for a
74dirty rate limit is from 0 to 1.67772e+07. The default value is 0.</p></li>
75</ul>
76<p>Click the <em>SQL</em> tab to continue.</p>
77<p>Your entries in the <em>Resource Group</em> dialog generate a SQL command. Use the
78<em>SQL</em> tab for review; revisit the <em>General</em> tab to make any changes to the SQL
79command.</p>
80<section id="example">
81<h2>Example<a class="headerlink" href="#example" title="Link to this heading">¶</a></h2>
82<p>The following is an example of the sql command generated by selections made in
83the <em>Resource Group</em> dialog:</p>
84<img alt="Resource Group dialog sql tab" class="align-center" src="_images/resource_group_sql.png" />
85<p>The example creates a resource group named <em>acctg</em> that sets <em>cpu_rate_limit</em>
86to <em>2</em>, and <em>dirty_rate_limit</em> to <em>6144</em>.</p>
87<ul class="simple">
88<li><p>Click the Info button (<em>i</em>) to access online SQL syntax reference material.</p></li>
89<li><p>Click the Help button (<em>?</em>) to access online documentation about Resource Groups.</p></li>
90<li><p>Click the <em>Save</em> button to save work.</p></li>
91<li><p>Click the <em>Close</em> button to exit without saving work.</p></li>
92<li><p>Click the <em>Reset</em> button to restore configuration parameters.</p></li>
93</ul>
94</section>
95</section>
96
97
98 <div class="clearer"></div>
99 </div>
100 </div>
101 </div>
102 <div class="sphinxsidebar" role="navigation" aria-label="main navigation">
103 <div class="sphinxsidebarwrapper">
104 <div>
105 <h3><a href="index.html">Table of Contents</a></h3>
106 <ul>
107<li><a class="reference internal" href="#">Resource Group Dialog</a><ul>
108<li><a class="reference internal" href="#example">Example</a></li>
109</ul>
110</li>
111</ul>
112
113 </div>
114<h3><a href="index.html">Table of Contents</a></h3>
115<ul class="current">
116<li class="toctree-l1"><a class="reference internal" href="getting_started.html">Getting Started</a></li>
117<li class="toctree-l1"><a class="reference internal" href="external_database.html">External database for pgAdmin user settings</a></li>
118<li class="toctree-l1"><a class="reference internal" href="connecting.html">Connecting To A Server</a></li>
119<li class="toctree-l1 current"><a class="reference internal" href="managing_cluster_objects.html">Managing Cluster Objects</a><ul class="current">
120<li class="toctree-l2"><a class="reference internal" href="database_dialog.html">Database Dialog</a></li>
121<li class="toctree-l2 current"><a class="current reference internal" href="#">Resource Group Dialog</a></li>
122<li class="toctree-l2"><a class="reference internal" href="role_dialog.html">Login/Group Role Dialog</a></li>
123<li class="toctree-l2"><a class="reference internal" href="tablespace_dialog.html">Tablespace Dialog</a></li>
124<li class="toctree-l2"><a class="reference internal" href="replica_nodes_dialog.html">Replica Node Dialog</a></li>
125<li class="toctree-l2"><a class="reference internal" href="role_reassign_dialog.html">Role Reassign/Drop Own Dialog</a></li>
126</ul>
127</li>
128<li class="toctree-l1"><a class="reference internal" href="managing_database_objects.html">Managing Database Objects</a></li>
129<li class="toctree-l1"><a class="reference internal" href="modifying_tables.html">Creating or Modifying a Table</a></li>
130<li class="toctree-l1"><a class="reference internal" href="management_basics.html">Management Basics</a></li>
131<li class="toctree-l1"><a class="reference internal" href="backup_and_restore.html">Backup and Restore</a></li>
132<li class="toctree-l1"><a class="reference internal" href="developer_tools.html">Developer Tools</a></li>
133<li class="toctree-l1"><a class="reference internal" href="processes.html">Processes</a></li>
134<li class="toctree-l1"><a class="reference internal" href="pgagent.html">pgAgent</a></li>
135<li class="toctree-l1"><a class="reference internal" href="contributions.html">pgAdmin Project Contributions</a></li>
136<li class="toctree-l1"><a class="reference internal" href="release_notes.html">Release Notes</a></li>
137<li class="toctree-l1"><a class="reference internal" href="licence.html">Licence</a></li>
138</ul>
139
140<search id="searchbox" style="display: none" role="search">
141 <h3 id="searchlabel">Quick search</h3>
142 <div class="searchformwrapper">
143 <form class="search" action="search.html" method="get">
144 <input type="text" name="q" aria-labelledby="searchlabel" autocomplete="off" autocorrect="off" autocapitalize="off" spellcheck="false"/>
145 <input type="submit" value="Go" />
146 </form>
147 </div>
148</search>
149<script>document.getElementById('searchbox').style.display = "block"</script>
150 </div>
151<div id="sidebarbutton" title="Collapse sidebar">
152<span>«</span>
153</div>
154
155 </div>
156 <div class="clearer"></div>
157 </div>
158 <div class="related" role="navigation" aria-label="related navigation">
159 <h3>Navigation</h3>
160 <ul>
161 <li class="right" style="margin-right: 10px">
162 <a href="genindex.html" title="General Index"
163 >index</a></li>
164 <li class="right" >
165 <a href="role_dialog.html" title="Login/Group Role Dialog"
166 >next</a> |</li>
167 <li class="right" >
168 <a href="database_dialog.html" title="Database Dialog"
169 >previous</a> |</li>
170 <li class="nav-item nav-item-0"><a href="index.html">pgAdmin 4 8.6 documentation</a> »</li>
171 <li class="nav-item nav-item-1"><a href="managing_cluster_objects.html" >Managing Cluster Objects</a> »</li>
172 <li class="nav-item nav-item-this"><a href="">Resource Group Dialog</a></li>
173 </ul>
174 </div>
175 <div class="footer" role="contentinfo">
176 <div class="related" role="navigation" aria-label="related navigation">
177 <ul>
178 <li class="left" style="margin-left: 10px">© Copyright (C) 2013 - 2024, The pgAdmin Development Team.</li>
179 <li class="right" style="margin-right: 10px"><a href="genindex.html" title="General Index" accesskey="I">index</a></li>
180 <li class="right" ><a href="role_dialog.html" title="Login/Group Role Dialog" accesskey="N">next</a> |</li>
181 <li class="right" ><a href="database_dialog.html" title="Database Dialog" accesskey="P">previous</a> |</li>
182 </ul>
183 </div>
184 </div>
185 </body>
186</html>