Ho RobertRw,log,noatime are the options usedThanksDerrick
-------- Original message --------From: Robert Swindells <[email protected]>
Date: 2021-02-20 11:36 a.m. (GMT-05:00) To: Derrick Lobo <[email protected]>
Cc: [email protected] Subject: Re: timeouts connecting to pgsql database
Derrick Lobo <[email protected]> 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
filesare located ? Are you using wapbl(4) ?
