From: | Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Tracking disk writes? (again) |
Date: | 2007-03-12 18:15:14 |
Message-ID: | 45F598B2.30204@cox.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)myemma(dot)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-----
From | Date | Subject | |
---|---|---|---|
Next Message | Martijn van Oosterhout | 2007-03-12 18:31:06 | Re: Tracking disk writes? (again) |
Previous Message | Stefan Berglund | 2007-03-12 18:15:01 | Re: Is This A Set Based Solution? |