Re: Tracking disk writes? (again) - Mailing list pgsql-general

From Ron Johnson
Subject Re: Tracking disk writes? (again)
Date
Msg-id 45F598B2.30204@cox.net
Whole thread Raw
In response to Re: Tracking disk writes? (again)  (Erik Jones <erik@myemma.com>)
Responses Re: Tracking disk writes? (again)
List pgsql-general
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 03/12/07 12:16, Erik Jones wrote:
>
> On Mar 12, 2007, at 11:46 AM, Harald Armin Massa wrote:
>
>> Erik,
>>
>> for solaris I think dtrace can be of help:
>>
>> http://www.opensolaris.org/os/community/dtrace/
>>
>> PostgreSQL 8.2 introduced dtrace-ability.
>>
>> From what I read it is specifically created to do this kind of
>> measurement.
>
> Hmm... That would be a particulary heavy weight solution to what I was
> hoping for.  Basically, I'm looking to poll the db or "something" to get
> either the total number of block or page writes done by the db either
> ever or since my last reading.  That way I can graph disk writes over
> time and compare to the graphs I've already got for transactions
> committed, transactios rolled back, disk blocks read from disk, and disk
> blocks found in cache.

Like a system montitor that tracks reads, writes, transactions, etc?

>
> erik jones <erik@myemma.com>
> sofware developer
> 615-296-0838
> emma(r)

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFF9ZiyS9HxQb37XmcRAiNKAKCxG7RJUEQTpyU6N6bqlllOcvUJ6wCfZh+8
7s3LprWsR2IEB3n+FwyLy58=
=cPIV
-----END PGP SIGNATURE-----

pgsql-general by date:

Previous
From: Erik Jones
Date:
Subject: Re: Tracking disk writes? (again)
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Tracking disk writes? (again)