[pgpool-general: 5561] Sizing RAM for PGPPOL

DAL GRANDE, Thierry tdalgrande at prosodie.com
Wed Jun 7 01:33:50 JST 2017


As you can read, i'm a french DBA. So, all apologizes for my English level.

I begin with pgpool by install a simple configuration
Pgppol in stand alone (no watchdog) and posgresql cluster with streaming réplication
Pgpool version = 3.5.4
Postgresql version = 9.3.2

My first question :
- how I can configure the ram of the pgpool server ? what is average amount of Ram using by one connection ?
Actually, I have 4GB RAM.
But I configured pgpool with :
- num_init_children = 400
- max_pool = 1
And when I have more than 330 connections, the server filed with out of memory

Moreover, I configured memcache with default settings.
What is the behavior  of pgpool  when memory_cache_enabled=off ?

Thanks in advance



Dal Grande Thierry - Administrateur de base de données
Tél. : +33 (0)
tdalgrande at prosodie.com<mailto:tdalgrande at prosodie.com>

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20170606/89a5656e/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.gif
Type: image/gif
Size: 3368 bytes
Desc: image001.gif
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20170606/89a5656e/attachment.gif>

More information about the pgpool-general mailing list