Re: Identifying the nature of blocking I/O - Mailing list pgsql-performance

From RW
Subject Re: Identifying the nature of blocking I/O
Date
Msg-id 48B26E18.7020204@tauceti.net
Whole thread Raw
In response to Re: Identifying the nature of blocking I/O  ("Alexander Staubo" <alex@bengler.no>)
List pgsql-performance
This matches not exactly the topic but it is sometimes helpfull.
If you've enabled I/O accounting and a kernel >= 2.6.20 (needs
to be compiled with

**CONFIG_TASKSTATS=y
CONFIG_TASK_DELAY_ACCT=y
CONFIG_TASK_XACCT=y
CONFIG_TASK_IO_ACCOUNTING=y
)

and sysstat package (>= 7.1.5) installed you can use "pidstat"
command which show's you the processes doing I/O in kb/sec.

Robert

**


Alexander Staubo wrote:
> On Mon, Aug 25, 2008 at 3:34 AM, Scott Carey <scott@richrelevance.com> wrote:
>
>> DTrace is available now on MacOSX, Solaris 10, OpenSolaris, and FreeBSD.
>> Linux however is still in the dark ages when it comes to system monitoring,
>> especially with I/O.
>>
>
> While that's true, newer 2.6 kernel versions at least have I/O
> accounting built in, something which only used to be available through
> the "atop" accounting kernel patch:
>
> $ cat /proc/22785/io
> rchar: 31928
> wchar: 138
> syscr: 272
> syscw: 4
> read_bytes: 0
> write_bytes: 0
> cancelled_write_bytes: 0
>
> Alexander.
>
>


pgsql-performance by date:

Previous
From: "Alexander Staubo"
Date:
Subject: Re: Identifying the nature of blocking I/O
Next
From: "Fernando Hevia"
Date:
Subject: Re: Big delete on big table... now what?