<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" "http://www.w3.org/TR/REC-html40/loose.dtd">
<html><body><p>Hello PGPOOL team,<br>I have a problem regarding pgpool server load. Our cluster consists of 2 pgpool servers (watchdog) and 2 postgresql servers (master-slave). Within a few days of restarting the pgpool service, the average server load is at a high level load average : 15-20 on 15 min load. After restart pgpool load average drops to low values, but every day there is a successive increase in load average (but count of connections is the same all time). At the highest load average, the RAM usage is about 6,5GB, but the processor is used to the max.<br><br>QUESTION: What can cause such an increase in server load? <br><br>Currently, our PG cluster has a size of about 600GB, about 1000 connections to several bases, of which in many cases connections are short but there are many at once with high frequency. Pgpool server with centos 7 have Intel(R) Xeon(R) CPU X5650 @ 2.67GHz and 64GB ram.<br><br>Below I present part of the configuration of pool connection and life time and attach screen from Icinga monitor of load average last 2 weeks.<br><br># -----<br>listen_backlog_multiplier = 2<br> # Set the backlog parameter of listen(2) to<br> # num_init_children * listen_backlog_multiplier.<br> # (change requires restart)<br>serialize_accept = off<br> # whether to serialize accept() call to avoid thundering herd problem<br> # (change requires restart)<br>reserved_connections = 0<br>#-----------<br><br>num_init_children = 500<br> # Number of concurrent sessions allowed<br> # (change requires restart)<br>max_pool = 4<br> # Number of connection pool caches per connection<br> # (change requires restart)<br># - Life time -<br><br>child_life_time = 300<br> # Pool exits after being idle for this many seconds<br>child_max_connections = 2005<br> # Pool exits after receiving that many connections<br> # 0 means no exit<br>connection_life_time = 1000<br> # Connection to backend closes after being idle for this many seconds<br> # 0 means no close<br>client_idle_limit = 4000<br><br><br>Regards,<br>Radoslaw Szczygiel<br data-mce-bogus="1"><style type="text/css">#icselection13 {width: 100% !important; height: 100% !important; padding-top: 0px !important; overflow: visible !important;}</style> <br><br><div class="public_gallery_body">Zobacz galerię obrazków z wiadomości- <a href="http://zdjecia.interia.pl/galeria,gcsi,001A1CEA440F58F204E378039B883E1A5D9A459A" style="color:#318fcd; text-decoration: none" target="_blank">kliknij link</a><br><br><a class="public_gallery_body_img" href="http://zdjecia.interia.pl/galeria,gcsi,001A1CEA440F58F204E378039B883E1A5D9A459A" target="_blank"><img src="cid:public_gallery_preview"></a></div></public_gallery_body></p></body></html>