<div dir="ltr"><span style="font-size:12.8px">If you do not use result cache - minimal configuration (1-2 cores, 1GB RAM) will do well, but it depends on your througoutput. If you will have thousands of connections with hundreds of tps each, you may need more cpu power.</span><div style="font-size:12.8px">And if you will log statements - you wil need disk space and fast disks (SSD?).</div><div style="font-size:12.8px">If you have minimal logging, no result caching on pgpool and moderate load - pgpool does not require much resources. We used to have two hot standby "load balancer" VMs with nginx, rabbitmq, pgpool, and memcache sharing one failover ip. Both have 4G RAM and 8 cores, but it is an overkill and their load average is pathetic even on traffic spikes.</div><div style="font-size:12.8px"><br></div><div style="font-size:12.8px">With best regards, Sergey Melekhin</div></div><div class="gmail_extra"><br clear="all"><div><div class="gmail_signature" data-smartmail="gmail_signature">С Уважением, Сергей Мелехин.</div></div>
<br><div class="gmail_quote">2016-06-29 3:48 GMT+10:00 Souza, Belinda <span dir="ltr"><<a href="mailto:Belinda.Souza@staples.com" target="_blank">Belinda.Souza@staples.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div lang="EN-US" link="blue" vlink="purple">
<div>
<p class="MsoNormal">All –<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">We are looking to set up our first pgpool VM servers. It is our intention to use statement load balancing, connection pooling, and watchdog for pgpool H/A along with streaming replication.<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Any advice on how to spec out the VM server for cpu and memory ?<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Thanks,<u></u><u></u></p>
<p class="MsoNormal"> Belinda<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
</div>
<br>_______________________________________________<br>
pgpool-general mailing list<br>
<a href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a><br>
<a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" rel="noreferrer" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br>
<br></blockquote></div><br></div>