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

[Tatsuo Ishii]

Good suggestion!

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp

> 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
> 
> $B'3(B $B'5'S'Q'X'V'_'Z'V'^(B, $B'3'V'b'T'V'[(B $B'.'V']'V'g'Z'_(B.
> 
> 2016-06-29 3:48 GMT+10:00 Souza, Belinda <Belinda.Souza at staples.com>:
> 
>> All $(Q#|(B
>>
>>
>>
>> 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
>>
>>