<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal">Here’s a connection directly to the database:<o:p></o:p></p>
<p class="MsoNormal">-bash-4.1$ time psql -h localhost -p 5493 -c 'select 1;'<o:p></o:p></p>
<p class="MsoNormal">?column? <o:p></o:p></p>
<p class="MsoNormal">----------<o:p></o:p></p>
<p class="MsoNormal"> 1<o:p></o:p></p>
<p class="MsoNormal">(1 row)<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">real 0m0.010s<o:p></o:p></p>
<p class="MsoNormal">user 0m0.001s<o:p></o:p></p>
<p class="MsoNormal">sys 0m0.004s<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Here’s a connection thru PGPool:<o:p></o:p></p>
<p class="MsoNormal">-bash-4.1$ time psql -h localhost -c 'select 1;'<o:p></o:p></p>
<p class="MsoNormal">?column? <o:p></o:p></p>
<p class="MsoNormal">----------<o:p></o:p></p>
<p class="MsoNormal"> 1<o:p></o:p></p>
<p class="MsoNormal">(1 row)<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">real 0m42.962s<o:p></o:p></p>
<p class="MsoNormal">user 0m0.005s<o:p></o:p></p>
<p class="MsoNormal">sys 0m0.003s<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Here’s a trace route from the PGPool host to the database primary host…doesn’t appear to be network slowness:<o:p></o:p></p>
<p class="MsoNormal">-bash-4.1$ traceroute rtp-apl-psg1<o:p></o:p></p>
<p class="MsoNormal">traceroute to rtp-apl-psg1 (10.83.105.93), 30 hops max, 60 byte packets<o:p></o:p></p>
<p class="MsoNormal">1 rtp5-ae72-dci02n-gw2-vla310.cisco.com (10.83.92.3) 0.549 ms rtp5-aa72-dci02n-gw1-vla310.cisco.com (10.83.92.2) 1.632 ms rtp5-ae72-dci02n-gw2-vla310.cisco.com (10.83.92.3) 0.652 ms<o:p></o:p></p>
<p class="MsoNormal">2 rtp-apl-psg1.cisco.com (10.83.105.93) 0.158 ms 0.383 ms 0.246 ms<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">PGPool is holding 1024 sessions open…the database is configured to allow 1500, so PGPool is not queueing a connection request. Load-balancing and caching are disabled in PGPool. Multiple queries on the same session return quickly, it’s
the process of connecting that is seeing the delay.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">How do I troubleshoot this behavior?<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thanks in advance,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="1086" style="width:407.25pt">
<tbody>
<tr>
<td colspan="3" style="padding:0in 0in 0in 0in">
<p class="MsoNormal"><img width="543" height="70" style="width:5.6562in;height:.7291in" id="Picture_x0020_1" src="cid:image005.png@01D265E1.C6F297C0" alt="banner2"><span style="font-size:12.0pt;font-family:"Times New Roman",serif"><o:p></o:p></span></p>
</td>
</tr>
<tr style="height:7.5pt">
<td style="padding:0in 0in 0in 0in;height:7.5pt">
<p class="MsoNormal"><span style="font-size:1.0pt;font-family:"Times New Roman",serif"> <o:p></o:p></span></p>
</td>
<td style="padding:0in 0in 0in 0in;height:7.5pt"></td>
<td style="padding:0in 0in 0in 0in;height:7.5pt"></td>
</tr>
<tr>
<td nowrap="" valign="top" style="padding:0in 0in 0in .25in">
<p class="MsoNormal"><b><span style="font-size:8.5pt;font-family:"Arial",sans-serif;color:#666666">David Sisk</span></b><span style="font-size:8.5pt;font-family:"Arial",sans-serif;color:#666666"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:"Arial",sans-serif;color:#666666">Engineer - Software<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:"Arial",sans-serif;color:#666666"><a href="mailto:dsisk@cisco.com"><span style="color:#666666;text-decoration:none">dsisk@cisco.com</span></a></span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:"Arial",sans-serif;color:#666666">Tel:
<o:p></o:p></span></p>
</td>
<td width="550" valign="top" style="width:206.25pt;padding:0in 0in 0in 15.0pt">
<p class="MsoNormal"><b><span style="font-size:8.5pt;font-family:"Arial",sans-serif;color:#666666">Cisco Systems, Inc.<o:p></o:p></span></b></p>
<p class="MsoNormal"><span style="font-size:8.5pt;font-family:"Arial",sans-serif;color:#666666">7025-6 Kit Creek Road PO Box 14987<br>
RESEARCH TRIANGLE PARK<br>
27709-4987<br>
United States<br>
cisco.com<o:p></o:p></span></p>
</td>
<td style="padding:0in 0in 0in 0in"></td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:12.0pt;font-family:"Times New Roman",serif;display:none"><o:p> </o:p></span></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="800" style="width:300.0pt">
<tbody>
<tr>
<td style="padding:0in 15.0pt 0in .25in">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Arial",sans-serif;color:#009900"><img border="0" width="18" height="19" style="width:.1875in;height:.1979in" id="Picture_x0020_3" src="cid:image006.png@01D265E1.C6F297C0" alt="http://www.cisco.com/assets/swa/img/thinkbeforeyouprint.gif">Think
before you print.<o:p></o:p></span></p>
</td>
</tr>
<tr>
<td style="padding:0in 15.0pt 0in .25in">
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Arial",sans-serif;color:#999999">This email may contain confidential and privileged material for the sole use of the intended recipient. Any review, use, distribution or disclosure by others is
strictly prohibited. If you are not the intended recipient (or authorized to receive for the recipient), please contact the sender by reply email and delete all copies of this message.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:"Arial",sans-serif;color:#999999">Please
<a href="http://www.cisco.com/web/about/doing_business/legal/cri/index.html" title="Legal Information">
<span style="color:#0E58A0">click here</span></a> for Company Registration Information.<o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>