[pgpool-general: 4745] Re: pgpool vm server spec ?

[Сергей Мелехин]

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.
And if you will log statements - you wil need disk space and fast disks
(SSD?).
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.

With best regards, Sergey Melekhin

С Уважением, Сергей Мелехин.

2016-06-29 3:48 GMT+10:00 Souza, Belinda <Belinda.Souza at staples.com>:

> All –
>
>
>
> 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.
>
>
>
> Any advice on how to spec out the VM server for cpu and memory ?
>
>
>
>
>
> Thanks,
>
>   Belinda
>
>
>
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20160629/0feb173f/attachment.html>