[pgpool-general: 4502] Re: Determining pgpool child memory footprint

[Wolf Schwurack]

What OS is your pgpool server?  We run on Ubuntu and was always out of memory until I made configuration changes on the OS.

Before change using 100% of 16G
After changes using 4% of 16G

Here's a link of the changes I make

http://www.nateware.com/linux-network-tuning-for-2013.html#.Vs4GNpMrJE4

Wolfgang Schwurack
Database/System Administrator



-----Original Message-----
From: pgpool-general-bounces at pgpool.net [mailto:pgpool-general-bounces at pgpool.net] On Behalf Of Kennedy, Robert
Sent: Monday, February 29, 2016 10:47 AM
To: pgpool-general at pgpool.net
Subject: [pgpool-general: 4501] Determining pgpool child memory footprint


We are attempting to size the memory for a pgpool-II 3.5.0 instance and would like to know what things a child will use private resident memory for above and beyond what is necessary for TCP connection and socket handling. We are not using memcache and are not using load balancing, failover, or replication. In this environment pgpool is strictly used to manage a flood of connections for a distributed application that cannot do its own pooling. There is only one <user,database> tuple used for all the connections and nearly all of the connections consist of a single row UPDATE.

In our testing we've seen widely varying amounts of resident memory usage for pgpool children and wonder what is driving it. We believe our various test cases are not so different in their behavior as to generate as much difference as we are seeing between test runs.

No memory appears to be leaking, and the children are being recycled without issue when the service is idle.

Cheers,
Robert Kennedy


_______________________________________________
pgpool-general mailing list
pgpool-general at pgpool.net
http://www.pgpool.net/mailman/listinfo/pgpool-general