[pgpool-general: 3799] Max Connections

[Robert Kennedy]

Hi Guys

I'm struggling to get my max connection correct at the moment.

>From my understanding,

num_init_children = 500
max_pool = 3

would result in a max of 1500 connections. Based on the combination of username and database. However on the postgres server I see 45 of the following in ps

postgres 29717  0.0  0.2 1320792 11468 ?       Ss   10:44   0:00 postgres: DB1 DB1 X.X.X.X(34529) idle

Eventually I get very strange behave from my webservers as they seem to get 0 result from there queries. This is causing havoc at the moment.

The postgres server is set to accept 1600 connection.

Thanks

Rob





Robert Kennedy| Software & Systems Developer

Tel: 011 557 5729 | Ext:229 | Cell: 084 998 9850

Email: robert at uwiniwin.co.za | Site: www.uwiniwin.co.za
Address: The Oval Office Park , Ground Floor Kingsmead, Meadowbrook Lane, Bryanston

[site-award-logo]

[site-aita-logo]

[cid:image003.jpg at 01D0A4FD.7A42BE60]<https://twitter.com/intent/follow?original_referer=http%3A%2F%2Fwww.linkedin.com%2Fprofile%2Fview%3Fid%3D7202140%26locale%3Den_US%26trk%3Dtyah&region=follow_link&screen_name=sandmandavid&source=followbutton&variant=2.0>

[czxc]<http://www.facebook.com/UwinIwinIncentives>

[cid:image005.jpg at 01D0A4FD.7A42BE60]<http://www.linkedin.com/company/uwin-iwin-incentives?trk=fc_badge>

[cid:image006.jpg at 01D0A4FD.7A42BE60]<http://www.linkedin.com/company/uwin-iwin-incentives?trk=fc_badge>


[cid:image007.jpg at 01D0A4FD.7A42BE60]<http://www.uwiniwin.net/>


Please consider the environment before printing this email-

The views expressed in this e-mail are, unless otherwise stated, those of the author and not those of Uwin Iwin Incentives (PTY) LTD or its management. The information in this e-mail is confidential and is intended solely for the addressee. Access to this e-mail by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted in reliance on this is prohibited and may be unlawful. Whilst all reasonable steps are taken to ensure the accuracy and integrity of information and data transmitted electronically and to preserve the confidentiality thereof, no liability or responsibility whatsoever is accepted if information or data is, for whatever reason, corrupted or does not reach its intended destination.





-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20150612/752fa5eb/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 18555 bytes
Desc: image001.jpg
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20150612/752fa5eb/attachment.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.jpg
Type: image/jpeg
Size: 6804 bytes
Desc: image002.jpg
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20150612/752fa5eb/attachment-0001.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.jpg
Type: image/jpeg
Size: 10499 bytes
Desc: image003.jpg
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20150612/752fa5eb/attachment-0002.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image004.jpg
Type: image/jpeg
Size: 10491 bytes
Desc: image004.jpg
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20150612/752fa5eb/attachment-0003.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image005.jpg
Type: image/jpeg
Size: 17033 bytes
Desc: image005.jpg
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20150612/752fa5eb/attachment-0004.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image006.jpg
Type: image/jpeg
Size: 18821 bytes
Desc: image006.jpg
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20150612/752fa5eb/attachment-0005.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image007.jpg
Type: image/jpeg
Size: 72834 bytes
Desc: image007.jpg
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20150612/752fa5eb/attachment-0006.jpg>