title: max-pool-size for DB connections Keycloak version 11
body: <p>Trying to investigate an issue regarding a keycloak deployment.
  From the <a href="https://www.keycloak.org/docs/latest/server_installation/#modify-the-keycloak-datasource" rel="nofollow noreferrer">documentation</a> we're seeing that we should alter this property in the stanealone.xml to allow more</p>
  <p>However , after altering the standalone xml to this</p>
  <pre><code>                &lt;/datasource&gt;
                  &lt;datasource jndi-name=&quot;java:jboss/datasources/KeycloakDS&quot; pool-name=&quot;KeycloakDS&quot; enabled=&quot;true&quot; use-java-context=&quot;true&quot; use-ccm=&quot;true&quot;&gt;
                      &lt;connection-url&gt;jdbc:postgresql://${env.DB_ADDR:postgres}/${env.DB_DATABASE:keycloak}${env.JDBC_PARAMS:}&lt;/connection-url&gt;
                      &lt;driver&gt;postgresql&lt;/driver&gt;
                      &lt;pool&gt;
                          &lt;max-pool-size&gt;200&lt;/max-pool-size&gt;
                      &lt;/pool&gt;
  </code></pre>
  <p>When we allow the JMX connection to the management console I notice this
  <a href="https://i.stack.imgur.com/3pLYB.png" rel="nofollow noreferrer">max pool size showing 19</a></p>
  <p>Is there anything which could be overriding the max-pool-size setting we're using or how would one go about debugging where is derives the max-pool-size if not from the standalone.xml</p>