Re: [PERFORM] Please help me understand these numbers

2007-06-08 Thread Chris Hoover
On 6/8/07, Bill Moran <[EMAIL PROTECTED]> wrote: In response to "Chris Hoover" <[EMAIL PROTECTED]>: > On 6/8/07, Bill Moran <[EMAIL PROTECTED]> wrote: > > > > In response to "Chris Hoover" <[EMAIL PROTECTED]>: > > > > > I need some help. I have started taking snapshots of performance of my > >

Re: [PERFORM] Please help me understand these numbers

2007-06-08 Thread Bill Moran
In response to "Chris Hoover" <[EMAIL PROTECTED]>: > On 6/8/07, Bill Moran <[EMAIL PROTECTED]> wrote: > > > > In response to "Chris Hoover" <[EMAIL PROTECTED]>: > > > > > I need some help. I have started taking snapshots of performance of my > > > databases with concerns to io. I created a view

Re: [PERFORM] Please help me understand these numbers

2007-06-08 Thread Chris Hoover
On 6/8/07, Bill Moran <[EMAIL PROTECTED]> wrote: In response to "Chris Hoover" <[EMAIL PROTECTED]>: > I need some help. I have started taking snapshots of performance of my > databases with concerns to io. I created a view on each cluster defined as: > SELECT pg_database.datname AS database_

Re: [PERFORM] Please help me understand these numbers

2007-06-08 Thread Bill Moran
In response to "Chris Hoover" <[EMAIL PROTECTED]>: > I need some help. I have started taking snapshots of performance of my > databases with concerns to io. I created a view on each cluster defined as: > SELECT pg_database.datname AS database_name, > pg_stat_get_db_blocks_fetched(pg_database.oi

[PERFORM] Please help me understand these numbers

2007-06-08 Thread Chris Hoover
I need some help. I have started taking snapshots of performance of my databases with concerns to io. I created a view on each cluster defined as: SELECT pg_database.datname AS database_name, pg_stat_get_db_blocks_fetched(pg_database.oid) AS blocks_fetched, pg_stat_get_db_blocks_hit(pg_database.