<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title></title>
</head>
<body>
<div name="messageBodySection" style="font-size: 14px; font-family: -apple-system, BlinkMacSystemFont, sans-serif;">Hi,
<div><br /></div>
<div>Apologies if this has been discussed before, but if so I can’t find a relevant thread.</div>
<div><br /></div>
<div>We are experiencing some strange behavior on our PGPool nodes. In some of them, load average is well in excess of 100 – although CPU is over 70% idle (rest spent in system), so this pointed to I/O. Checking on AWS, we see that there is a lot of disk activity, including writes. This was surprising, as we did not expect the pgpool machines to have any significant disk usage, nor we can find anything in the documentation that would indicate it to be the case.</div>
<div><br /></div>
<div>After some sysdig usage, the only file getting heavily written to appears to be /var/log/postgresql/pgpool_status</div>
<div><br /></div>
<div>It is multiple 6 bytes writes a second, all with the same data, by pgpool. So this shouldn’t be a problem as it is not too much data. Except that it seems to be getting flushed right away (fsync?).</div>
<div><br /></div>
<div>Is this behavior expected? The PG node status have not changed at any time, there are two nodes, always up. Why would the file get rewritten dozens (even hundreds, depending on load) of times per second? </div>
<div><br /></div>
<div>Would this be caused by a misconfiguration?</div>
<div><br /></div>
<div>pgpool-II version 3.7.5 (amefuriboshi)<br /></div>
<div><br /></div>
<div>ps -ef | grep pgpool | wc -l<br />
507<br /></div>
<div><br /></div>
<div>sysdig -A -c echo_fds “fd.filename=pgpool_status"</div>
<div><br />
------ Write 6B to /var/log/postgresql/pgpool_status<br />
<br />
up<br />
up<br />
<br />
------ Write 6B to /var/log/postgresql/pgpool_status<br />
<br />
up<br />
up<br />
<br />
------ Write 6B to /var/log/postgresql/pgpool_status<br />
<br />
up<br />
up<br />
<br />
------ Write 6B to /var/log/postgresql/pgpool_status<br /></div>
</div>
<div name="messageSignatureSection"><br />
<div class="matchFont"><br style="font-size: 14px; font-family: -apple-system, BlinkMacSystemFont, sans-serif;" /></div>
<div class="matchFont">[This is repeated and scrolls by pretty fast]</div>
<div class="matchFont"><br style="font-size: 14px; font-family: -apple-system, BlinkMacSystemFont, sans-serif;" /></div>
<div class="matchFont">Thanks,
<div style="font-size: 14px; font-family: -apple-system, BlinkMacSystemFont, sans-serif;"><br style="font-size: 14px; font-family: -apple-system, BlinkMacSystemFont, sans-serif;" /></div>
<div style="font-size: 14px; font-family: -apple-system, BlinkMacSystemFont, sans-serif;">– Stephen</div>
</div>
</div>
</body>
</html>