<div dir="ltr">Hi Guys,<div><br></div><div>When I list the output of SHOW POOL_POOLS, all the pools have a <span style="color:rgb(68,0,0);font-family:monospace;font-size:medium">pool_counter=1 and a distinct </span><span style="color:rgb(68,0,0);font-family:monospace;font-size:medium">pool_backendpid.  To me this means that even though I have the same users connecting, with the same major/minor, connection pools aren&#39;t being reused.  Is that correct?  Here&#39;s a snippet (I have three backends):</span></div><div><span style="color:rgb(68,0,0);font-family:monospace;font-size:medium"><br></span></div><div> 141204   | 2020-07-01 11:04:21 | 0       | 0          | mobile-search-bff               | v-token-mo-mobile-s-yAjmcIzpEvK | 2020-07-01 12:16:19 | 3            | 0            | 1            | 12047           | 1<br> 141204   | 2020-07-01 11:04:21 | 0       | 1          | mobile-search-bff               | v-token-mo-mobile-s-yAjmcIzpEvK | 2020-07-01 12:16:19 | 3            | 0            | 1            | 60420           | 1<br> 141204   | 2020-07-01 11:04:21 | 0       | 2          | mobile-search-bff               | v-token-mo-mobile-s-yAjmcIzpEvK | 2020-07-01 12:16:19 | 3            | 0            | 1            | 137228          | 1<br> 141515   | 2020-07-01 11:04:21 | 1       | 0          | mobile-search-bff               | v-token-mo-mobile-s-yAjmcIzpEvK | 2020-07-01 12:16:19 | 3            | 0            | 1            | 12049           | 1<br> 141515   | 2020-07-01 11:04:21 | 1       | 1          | mobile-search-bff               | v-token-mo-mobile-s-yAjmcIzpEvK | 2020-07-01 12:16:19 | 3            | 0            | 1            | 60428           | 1<br> 141515   | 2020-07-01 11:04:21 | 1       | 2          | mobile-search-bff               | v-token-mo-mobile-s-yAjmcIzpEvK | 2020-07-01 12:16:19 | 3            | 0            | 1            | 137235          | 1<br> 173903   | 2020-07-01 12:11:17 | 0       | 0          | mobile-search-bff               | v-token-mo-mobile-s-yAjmcIzpEvK | 2020-07-01 12:16:19 | 3            | 0            | 1            | 12050           | 1<br> 173903   | 2020-07-01 12:11:17 | 0       | 1          | mobile-search-bff               | v-token-mo-mobile-s-yAjmcIzpEvK | 2020-07-01 12:16:19 | 3            | 0            | 1            | 60430           | 1<br> 173903   | 2020-07-01 12:11:17 | 0       | 2          | mobile-search-bff               | v-token-mo-mobile-s-yAjmcIzpEvK | 2020-07-01 12:16:19 | 3            | 0            | 1            | 137237          | 1<br> 173620   | 2020-07-01 12:10:42 | 0       | 0          | mobile-search-bff               | v-token-mo-mobile-s-yAjmcIzpEvK | 2020-07-01 12:16:19 | 3            | 0            | 1            | 12052           | 1<br> 173620   | 2020-07-01 12:10:42 | 0       | 1          | mobile-search-bff               | v-token-mo-mobile-s-yAjmcIzpEvK | 2020-07-01 12:16:19 | 3            | 0            | 1            | 60433           | 1<br> 173620   | 2020-07-01 12:10:42 | 0       | 2          | mobile-search-bff               | v-token-mo-mobile-s-yAjmcIzpEvK | 2020-07-01 12:16:19 | 3            | 0            | 1            | 137242          | 1<br> 173094   | 2020-07-01 12:09:36 | 0       | 0          | mobile-search-bff               | v-token-mo-mobile-s-yAjmcIzpEvK | 2020-07-01 12:16:19 | 3            | 0            | 1            | 12051           | 1<br> 173094   | 2020-07-01 12:09:36 | 0       | 1          | mobile-search-bff               | v-token-mo-mobile-s-yAjmcIzpEvK | 2020-07-01 12:16:19 | 3            | 0            | 1            | 60431           | 1<br> 173094   | 2020-07-01 12:09:36 | 0       | 2          | mobile-search-bff               | v-token-mo-mobile-s-yAjmcIzpEvK | 2020-07-01 12:16:19 | 3            | 0            | 1            | 137239          | 1<span style="color:rgb(68,0,0);font-family:monospace;font-size:medium"><br></span></div><div><br></div><div>The only thing I can think of is that it may have something to do with the user names (these are Vault-generated users).</div><div><br></div><div>I do have the connection cache parameter on:</div><div><pre style="color:rgb(0,0,0);font-family:Menlo;font-size:9pt">connection_cache on</pre></div><div>I&#39;m using PgPool-II v. 4.1.1.  </div><div><br></div><div>Thanks,</div><div><br></div><div>Matt</div></div>