From: Jeff Davis <pgsql@j-davis.com>
To: Chris Hoover <revoohc@gmail.com>
Cc: PGSQL Performance <pgsql-performance@postgresql.org>
Subject: Re: Is this true?
Date: Wed, 06 Jun 2007 14:37:04 -0700
Message-ID: <1181165824.7660.157.camel@dogma.v10.wvs> (raw)
In-Reply-To: <1d219a6f0706061358i49823219iee0354b357b4dd02@mail.gmail.com>
References: <1d219a6f0706061358i49823219iee0354b357b4dd02@mail.gmail.com>
On Wed, 2007-06-06 at 16:58 -0400, Chris Hoover wrote:
> Question,
>
> Does (pg_stat_get_db_blocks_fetched(oid)-pg_stat_get_db_blocks_hit
> (oid)*8) = number of KB read from disk for the listed database since
> the last server startup?
That will give you the number of blocks requested from the OS. The OS
does it's own caching, and so many of those reads might come from the OS
buffer cache, and not the disk itself.
Also, if you're concerned with the number since the last server restart,
make sure you have stats_reset_on_server_start set appropriately.
Regards,
Jeff Davis
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: pgsql@j-davis.com, revoohc@gmail.com
Subject: Re: Is this true?
In-Reply-To: <1181165824.7660.157.camel@dogma.v10.wvs>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox