<div dir="ltr">Hi,<div><br></div><div>When I connect to pgpool on the slave, the first request is insanely slow, subsequent requests are fast.</div><div><br></div><div>Does anyone know why this might be?</div><div><br></div><div>Pgpool: 3.6.4, Postgres, 9.6.3</div><div><br></div><div>NOTE: it also seems to take a long time to connect to pgpool using psql.. i seem to remember an older version not having this delay</div><div><br></div><div>I've tried:</div><div><ul><li>with pool_hba turned on and off - no difference<br></li><li>i compiled pgpool (3.6.4) from source - no difference (was using the pgdg ubuntu 16.04 binaries before</li></ul></div><div><b><u>The below example showing the first request taking 58000ms! Subsequent queries take 72ms...</u></b></div><div><br></div><div>e.g.</div><div>
<p class="gmail-p1"><span class="gmail-s1">r<font face="monospace, monospace">oot@db-slave:~# sudo -u postgres psql -h127.0.0.1 -p5433 mydb</font></span></p>
<p class="gmail-p1"><span class="gmail-s1"><font face="monospace, monospace">sudo: unable to resolve host db-slave</font></span></p>
<p class="gmail-p1"><span class="gmail-s1"><font face="monospace, monospace">could not change directory to "/root": Permission denied</font></span></p>
<p class="gmail-p1"><span class="gmail-s1"><font face="monospace, monospace">psql (9.6.3)</font></span></p>
<p class="gmail-p1"><span class="gmail-s1"><font face="monospace, monospace">Type "help" for help.</font></span></p>
<p class="gmail-p1"><span class="gmail-s1"><font face="monospace, monospace">mydb=# \timing</font></span></p>
<p class="gmail-p1"><span class="gmail-s1"><font face="monospace, monospace">Timing is on.</font></span></p>
<p class="gmail-p1"><span class="gmail-s1"><font face="monospace, monospace">mydb=# select * from users where id=90000;</font></span></p>
<p class="gmail-p1"><span class="gmail-s1"><font face="monospace, monospace" color="#ff0000"><b>Time: 58593.186 ms</b></font></span></p>
<p class="gmail-p1"><span class="gmail-s1"><span style="font-family:monospace,monospace">mydb</span><font face="monospace, monospace">=# select * from users where id=90000;</font></span></p>
<p class="gmail-p1"><span class="gmail-s1"><font face="monospace, monospace" color="#ff0000"><b>Time: 0.750 ms</b></font></span></p>
<p class="gmail-p1"><span class="gmail-s1"><span style="font-family:monospace,monospace">mydb</span><font face="monospace, monospace">=# select * from users where id=80000;</font></span></p><p class="gmail-p1"><span class="gmail-s1"><font face="monospace, monospace" color="#ff0000"><b>Time: 72.081ms</b></font></span></p><p class="gmail-p1"><span class="gmail-s1"><font face="monospace, monospace">mydb=# select * from designs where id=78884;</font></span></p><p class="gmail-p1"><span class="gmail-s1"><font face="monospace, monospace">
</font></span></p><p class="gmail-p1"><span class="gmail-s1"><font face="monospace, monospace" color="#ff0000"><b>Time: 1.648 ms</b></font></span></p>
<p class="gmail-p1"><span class="gmail-s1">Time: 72.081 ms</span></p>
<p class="gmail-p1"><span class="gmail-s1">picto=#<span class="gmail-Apple-converted-space"> </span></span></p></div></div>