Hi. This is a collection of very basic monitoring sql statements returning
one numerical value. We switched from nagios to prtg network monitoring. I
had to reformulate the monitoring statements, making them invariable worse,
but like this they work with PRTG.
For Postgres 8.1 and 8.4
A. Preparat
On Wed, Jan 2, 2013 at 1:38 AM, Jesper Krogh wrote:
> I do suspect you have too much IO going on for the hardware.
>
> I would trim down. /proc/sys/vm/dirty_ratio and dirty_background_ratio to
> 2 and 1 and see if the problem goes away.
>
> And establish graphing of the io-wait numbers if you don
