<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=iso-8859-1">
<meta name="Generator" content="Microsoft Word 14 (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:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Texte de bulles Car";
margin:0cm;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";
mso-fareast-language:EN-US;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.TextedebullesCar
{mso-style-name:"Texte de bulles Car";
mso-style-priority:99;
mso-style-link:"Texte de bulles";
font-family:"Tahoma","sans-serif";}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 70.85pt 70.85pt;}
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="FR" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span lang="EN-US">Hi, <o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">As you can read, i’m a french DBA. So, all apologizes for my English level.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">I begin with pgpool by install a simple configuration
<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Pgppol in stand alone (no watchdog) and posgresql cluster with streaming réplication
<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Pgpool version = 3.5.4<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Postgresql version = 9.3.2<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">My first question : <o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">- how I can configure the ram of the pgpool server ? what is average amount of Ram using by one connection ?
<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Actually, I have 4GB RAM. <o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">But I configured pgpool with :<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">- num_init_children = 400<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">- max_pool = 1<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">And when I have more than 330 connections, the server filed with out of memory<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Moreover, I configured memcache with default settings.
<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">What is the behavior of pgpool when memory_cache_enabled=off ?<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Thanks in advance<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Verdana","sans-serif";color:#365F91;mso-fareast-language:FR">Cordialement,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;color:#17365D;mso-fareast-language:FR"><o:p> </o:p></span></p>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" style="border-collapse:collapse">
<tbody>
<tr>
<td width="124" valign="top" style="width:93.3pt;padding:0cm 5.4pt 0cm 5.4pt">
<p class="MsoNormal" style="margin-bottom:12.0pt"><a href="http://www.prosodie.com/"><span style="font-family:"Verdana","sans-serif";color:#1F497D;mso-fareast-language:FR;text-decoration:none"><img border="0" width="110" height="48" id="Image_x0020_1" src="cid:image001.gif@01D2DEF3.70899650" alt="Prosodie-signature"></span></a><span style="font-family:"Verdana","sans-serif";color:#1F497D;mso-fareast-language:FR"><o:p></o:p></span></p>
</td>
<td width="517" valign="top" style="width:387.8pt;padding:0cm 5.4pt 0cm 5.4pt">
<p class="MsoNormal"><b><span style="font-size:9.0pt;font-family:"Verdana","sans-serif";color:#00468C;mso-fareast-language:FR">Dal Grande Thierry – Administrateur de base de données
<br>
</span></b><span style="font-size:9.0pt;font-family:"Verdana","sans-serif";color:#00468C;mso-fareast-language:FR">PROSODIE
<br>
Tél. : +33 (0)1.34.49.16.47<br>
<a href="mailto:tdalgrande@prosodie.com"><span style="color:blue">tdalgrande@prosodie.com</span></a></span><span style="font-size:9.0pt;font-family:"Verdana","sans-serif";color:#1F497D;mso-fareast-language:FR"><o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span style="mso-fareast-language:FR"><o:p> </o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<span style="color: #808080; font-family: arial; font-size: 9px; line-height: 10px;">This message contains information that may be privileged or confidential and is the property of the Capgemini Group. It is intended only for the person to whom it is addressed. If you are not the intended recipient, you are not authorized to read, print, retain, copy, disseminate, distribute, or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message.</span></body>
</html>