Search Postgresql Archives

Re: Tracking disk writes? (again)

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



-----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@xxxxxxxxxx>
> 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-----


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux