Re: General performance/load issue

On 24 Listopad 2011, 15:27, Gaëtan Allart wrote:
> Hi Thomas,
>
> I will be using iotop ;)
> Right now, most i/o come from "postgres: wal writer process".

What do you mean by "most I/O" - how much data is it writing? Is there a
vacuum running at the same time? What other processes are doing I/O?

Post a few lines of "iostat -x 5" so we know what kind of I/O we're
dealing with.

> -> dirty :
>
> cat /proc/sys/vm/dirty_ratio 20
> cat /proc/sys/vm/dirty_background_ratio 10

This means the cache may contain up to 3.2GB of data before the system
starts to write them out on background, and about 6.4GB before the
processes can't use the write cache.

What about /proc/sys/vm/dirty_expire_centiseconds?

Is there something interesting in the postgresql.log? Autovacuum maybe?

Tomas