Ho Robert Rw,log,noatime are the options used Thanks Derrick -------- Original message -------- From: Robert Swindells <rjs%fdy2.co.uk@localhost> Date: 2021-02-20 11:36 a.m. (GMT-05:00) To: Derrick Lobo <derrick%givex.com@localhost> Cc: tech-kern%NetBSD.org@localhost Subject: Re: timeouts connecting to pgsql database Derrick Lobo <derrick%givex.com@localhost> wrote: >Not sure if anyone else has experienced the below, postgres configs can be >shared if needed, we have a few database servers running on 7.12 and 9 > >We recently noticed some problems with timeouts on some postgres database >servers. The machines don't appear to be heavily loaded, although they are >being used steadily. What we're seeing is that the machine is working fine. No >swapping, load average is below 1, and then it doesn't accept database >connections for about 10-20 seconds, and any queries on active connections >fail to return for that same time period. I tried running these commands in a >screen to get a better sense of the system state when the problem occurs: What filesystem options are you using for wherever the database files are located ? Are you using wapbl(4) ? |