<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:navy;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
.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"><span style="color:navy">Hi Guys<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:navy"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:navy">I’m struggling to get my max connection correct at the moment.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:navy"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:navy">From my understanding, <o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:navy"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:navy">num_init_children = 500<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:navy">max_pool = 3<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:navy"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:navy">would result in a max of 1500 connections. Based on the combination of username and database. However on the postgres server I see 45 of the following in ps<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:navy"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:navy">postgres 29717 0.0 0.2 1320792 11468 ? Ss 10:44 0:00 postgres: DB1 DB1 X.X.X.X(34529) idle<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:navy"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:navy">Eventually I get very strange behave from my webservers as they seem to get 0 result from there queries. This is causing havoc at the moment.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:navy"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:navy">The postgres server is set to accept 1600 connection.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:navy"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:navy">Thanks<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:navy"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:navy">Rob<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:navy"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:navy"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:navy"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:navy"><o:p> </o:p></span></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="1101" style="width:825.75pt">
<tbody>
<tr>
<td width="1184" valign="top" style="width:888.0pt;padding:0in 0in 0in 0in"></td>
</tr>
<tr>
<td style="padding:0in 0in 0in 0in">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><b><span style="font-size:12.0pt;color:navy">Robert Kennedy</span></b><span style="font-size:10.0pt;color:#134883">|</span><span style="font-size:10.5pt;color:#333333">
</span><b><span style="font-size:12.0pt;color:#0095D4">Software & Systems Developer</span></b><span style="font-size:10.5pt;color:#333333"><o:p></o:p></span></p>
</td>
</tr>
<tr style="height:19.5pt">
<td style="padding:0in 0in 0in 0in;height:19.5pt">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><b><span style="font-size:10.0pt;color:navy">Tel:</span></b><span style="font-size:10.0pt;color:navy"> 011 557 5729 | <b>Ext:</b>229 |
<b>Cell: </b>084 998 9850 </span><span style="font-size:10.5pt;color:#333333"><o:p></o:p></span></p>
</td>
</tr>
<tr style="height:20.25pt">
<td style="padding:0in 0in 0in 0in;height:20.25pt">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><b><span style="font-size:10.0pt;color:navy">Email:</span></b><span style="font-size:10.0pt;color:navy"> robert@uwiniwin.co.za</span><span style="font-size:10.5pt;color:navy">
</span><span style="font-size:7.5pt;color:navy">|</span><span style="font-size:10.5pt;color:navy">
</span><b><span style="font-size:10.0pt;color:navy">Site:</span></b><span style="font-size:10.5pt;color:navy">
</span><span style="font-size:10.0pt;color:navy">www.uwiniwin.co.za</span><span style="font-size:10.0pt;color:#333333"><br>
</span><b><span style="font-size:10.0pt;color:navy">Address: </span></b><span style="font-size:10.0pt;color:navy">The Oval Office Park , Ground Floor Kingsmead, Meadowbrook Lane, Bryanston</span><span style="font-size:10.0pt;color:#333333">
</span><span style="font-size:10.5pt;color:#333333"><o:p></o:p></span></p>
</td>
</tr>
<tr style="height:30.75pt">
<td style="padding:0in 0in 0in 0in;height:30.75pt">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="199" style="width:149.25pt">
<tbody>
<tr>
<td width="44" style="width:33.0pt;padding:0in 0in 0in 0in">
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:navy"><img width="44" height="36" id="_x0000_i1031" src="cid:image001.jpg@01D0A4FD.7A42BE60" alt="site-award-logo"></span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:navy"><o:p></o:p></span></p>
</td>
<td width="66" style="width:49.5pt;padding:0in 0in 0in 0in">
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:navy"><img width="65" height="36" id="_x0000_i1030" src="cid:image002.jpg@01D0A4FD.7A42BE60" alt="site-aita-logo"></span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:navy"><o:p></o:p></span></p>
</td>
<td width="33" style="width:24.75pt;padding:0in 0in 0in 0in">
<p class="MsoNormal"><a href="https://twitter.com/intent/follow?original_referer=http%3A%2F%2Fwww.linkedin.com%2Fprofile%2Fview%3Fid%3D7202140%26locale%3Den_US%26trk%3Dtyah®ion=follow_link&screen_name=sandmandavid&source=followbutton&variant=2.0"><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:blue;text-decoration:none"><img border="0" width="33" height="35" id="_x0000_i1029" src="cid:image003.jpg@01D0A4FD.7A42BE60"></span></a><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:navy"><o:p></o:p></span></p>
</td>
<td width="27" style="width:20.25pt;padding:0in 0in 0in 0in">
<p class="MsoNormal"><a href="http://www.facebook.com/UwinIwinIncentives"><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:blue;text-decoration:none"><img border="0" width="33" height="35" id="_x0000_i1028" src="cid:image004.jpg@01D0A4FD.7A42BE60" alt="czxc"></span></a><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:navy"><o:p></o:p></span></p>
</td>
<td width="41" style="width:30.75pt;padding:0in 0in 0in 0in">
<p class="MsoNormal"><a href="http://www.linkedin.com/company/uwin-iwin-incentives?trk=fc_badge"><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:blue;text-decoration:none"><img border="0" width="33" height="35" id="_x0000_i1027" src="cid:image005.jpg@01D0A4FD.7A42BE60"></span></a><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:navy"><o:p></o:p></span></p>
</td>
<td width="41" style="width:30.75pt;padding:0in 0in 0in 0in">
<p class="MsoNormal"><a href="http://www.linkedin.com/company/uwin-iwin-incentives?trk=fc_badge"><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:blue;text-decoration:none"><img border="0" width="65" height="36" id="_x0000_i1026" src="cid:image006.jpg@01D0A4FD.7A42BE60"></span></a><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:navy"><o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td style="padding:0in 0in 0in 0in">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="1177" style="width:882.75pt">
<tbody>
<tr style="height:80.25pt">
<td valign="top" style="padding:0in 0in 0in 0in;height:80.25pt">
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="540" style="width:405.0pt">
<tbody>
<tr>
<td style="border:solid lightgrey 1.0pt;padding:0in 0in 0in 0in">
<p class="MsoNormal"><a href="http://www.uwiniwin.net/"><span style="font-size:8.5pt;font-family:"Times New Roman",serif;color:blue;text-decoration:none"><img border="0" width="758" height="114" id="_x0000_i1025" src="cid:image007.jpg@01D0A4FD.7A42BE60"></span></a><span style="font-size:8.5pt;font-family:"Times New Roman",serif;color:#093362"><o:p></o:p></span></p>
</td>
</tr>
<tr>
<td valign="top" style="padding:0in 0in 0in 1.5pt">
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:navy"><o:p> </o:p></span></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="758" style="width:568.5pt">
<tbody>
<tr>
<td width="758" valign="top" style="width:568.5pt;padding:0in 0in 0in 1.5pt">
<p class="MsoNormal"><b><span style="font-size:7.5pt;color:#2A5E2D">Please consider the environment before printing this email-</span></b><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:navy"><o:p></o:p></span></p>
</td>
</tr>
<tr>
<td valign="top" style="padding:0in 0in 0in 1.5pt">
<p class="MsoNormal"><span style="font-size:7.5pt;color:#2A5E2D">The views expressed in this e-mail are, unless otherwise stated, those of the author and not those of Uwin Iwin Incentives (PTY) LTD or its management. The information in this e-mail is confidential
and is intended solely for the addressee. Access to this e-mail by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted in reliance on this is prohibited and may be unlawful.
Whilst all reasonable steps are taken to ensure the accuracy and integrity of information and data transmitted electronically and to preserve the confidentiality thereof, no liability or responsibility whatsoever is accepted if information or data is, for
whatever reason, corrupted or does not reach its intended destination.</span><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:navy"><o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>