On Mar 12, 2007, at 1:15 PM, Ron Johnson wrote:
-----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:
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?
Well, disk reads, cache hits, transactions commited, transactions rolled back, index size and usage, etc. are all able to be tracked vi the pg catalogue tables and views. But, I haven't seen anything that will give me numbers on actual disk writes done by the database.
sofware developer
615-296-0838
emma(r)